| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
