Home » Server Options » Streams & AQ » recover data from 10g Db to 9i
recover data from 10g Db to 9i [message #212544] Fri, 05 January 2007 15:33
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
Previous Topic: add_schema_rules LogMiner Build error
Next Topic: Problems with Oracle JMS Advanced Queuing
Goto Forum:
  


Current Time: Thu Mar 28 08:05:17 CDT 2024