Re: Partition Advice
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Jul 2004 11:49:10 -0700 (PDT)
Tanel
Quick advice. Do I need to drop the old partition and
create the new partition using Split partition or the
method directly will take care of it. I have currently
new table with no partition. In Original Table, It is
range partitioned with data and indexes in different
tablespace so as to make the Drop partition work
without unusable indexes error as we used to delete
old partition after a year or so.
Sanjay
--- Tanel_Põder <tanel.poder.003@xxxxxxx> wrote:
> You could use:
>
> alter table emp exchange partition old_partition
> with table employee;
>
> And then rebuild any indexes on this partition.
>
> That way the physical contents of old_partition in
> emp table table are
> replaced with contents of employee table (using a
> data dictionary update, no
> real data is moved around).
>
> If you are sure about validity of data in the
> employee table, you could add
> "without validation" clause to the exchange
> partition syntax, that way the
> exchange operation itself will be faster. There are
> some issues though, I
> recommend you to read Jonathan Lewis'es article on
> this:
> http://www.dbazine.com/jlewis17.shtml
>
> Tanel.
>
> ----- Original Message -----
> From: "Sanjay Mishra" <smishra_97@xxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Monday, July 26, 2004 9:14 PM
> Subject: Partition Advice
>
>
> >
> > I have a prod database where we have one of the
> big
> > table been partioned on Weekly basis and each week
> > data is around 40G. Today I checked that our RMAN
> > backup is still showing Sucess at the end but
> been
> > failing from last one week on one of the datafile
> and
> > generated an IO error and then found that there
> are
> > several block is been corrupted and it is Sun
> > platform. I cannot copy the 30 G datafile using
> any OS
> > utilities from one filesystem to another as it
> fail
> > with same error.
> >
> > Now I cannot recover as I don't have good backup
> of
> > this file but as the user are not accessing this
> old
> > partition and so there are no report been made and
> > system is fine. I had create new table now and
> > populated all of the 2 million record in it and
> only
> > lost 10 records. Now can somebody suggest as how
> can I
> > put this data back to the parititon. I am going to
> > drop the old parition and it is of no issue [ I
> hope
> > so ] as I had made the file offline and online
> > yesterday with problem and even bounced the
> database.
> > So is there any way that I can drop the old
> partition
> > and put this new data into this place. Original
> table
> > is emp and new recovered table is Employee
> >
> > Thanks for all help
>
>
>
----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
----------------------------------------------------------------
> To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
