| Recovering a dropped table [message #63468] |
Thu, 07 October 2004 13:42  |
Martin
Messages: 83
Registered: February 2000
|
Member |
|
|
Hello Oracle Gurus
I have a problem and am sure to find help here.
A table with 45 million rows got dropped.
Before dropping it, the dba had exported the records to an export file.
There are 6 indexes and 6 constraints attached to it.
So I had planned to create the table with no indexes (as its going to degrade the perfomance of importing 45 million rows) and no constraints
Then import the 45 million records and enable the constraints.
Could anyone come up with a better plan as to how to rebuild this table and import the 45 million records back.
Thanks
Martin
|
|
|
|
| Re: Recovering a dropped table [message #63476 is a reply to message #63468] |
Fri, 08 October 2004 01:56  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi,
As you said you already having a dumpfile of that dropped table again why you want to create a table just import the that file it automatically creates the table
when importing say indexes=n constraints=y
it will work
Regards
D.Dilip
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
