| recover data from 10g to 9i [message #212545] |
Fri, 05 January 2007 15:34  |
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 #212580 is a reply to message #212545] |
Fri, 05 January 2007 23:37  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
