Home » RDBMS Server » Backup & Recovery » recover data from 10g to 9i
recover data from 10g to 9i [message #212545] Fri, 05 January 2007 15:34 Go to next message
d_ponnilavan
Messages: 13
Registered: May 2005
Location: india
Junior Member
Hi,
Could some one tell me what is fastest method to recover table that has 20 GB data in 10g DB to a 9i DB?
Let me explain the situation...
I had data in table X around 60 GB, so I compressed and archived the data to 10g...now the table X in 10g has 20GB data...I've deleted the data in table 9i after the archive...

Due to some data issue, I need to recover the data in the table in 10g to 9i table...

I thought of going for these options
1. Select and insert into ----This takes more than 12 hrs & I don't want to do that, if there are some other ways to do...
2. Exp/Imp--will there be any compatibility issue?
3. SQL loader --will there be any compatibility issue?
Would be great if some one could explain the best way to do the restore


Thanks,
Ponnilavan
Re: recover data from 10g to 9i [message #212550 is a reply to message #212545] Fri, 05 January 2007 15:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How did you transfer it to the 10g database? If the only copy that you have resides in the 10g database, then you best option may be to just export from the 10g database using the 9i's export utility and import it into the 9i database using the 9i's import utility.
Re: recover data from 10g to 9i [message #212559 is a reply to message #212550] Fri, 05 January 2007 17:22 Go to previous messageGo to next message
d_ponnilavan
Messages: 13
Registered: May 2005
Location: india
Junior Member
I did insert/select method...but it is taking time....
I'll try imp/exp method as you suggested...THanks...
Re: recover data from 10g to 9i [message #212580 is a reply to message #212545] Fri, 05 January 2007 23:37 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
Keep in mind during export or import operation.
if export From Release 10.2  or import To Release 9.2 
then used exp utility from Release 9.2 
and for import use imp utility from Release 9.2 

if export From Release 10.2  or import To Release 9.0.1 
then used exp utility from Release 9.0.1
and for import use imp utility from Release 9.0.1 



hope this helps
Taj
Previous Topic: explain about backup and recovery(very urgent)
Next Topic: pl/sql code
Goto Forum:
  


Current Time: Thu Dec 08 22:19:33 CST 2016

Total time taken to generate the page: 0.20088 seconds