Home » RDBMS Server » Server Administration » Recovering a dropped table
- Recovering a dropped table [message #63468] Thu, 07 October 2004 13:42 Go to next message
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

Report message to a moderator

- Re: Recovering a dropped table [message #63476 is a reply to message #63468] Fri, 08 October 2004 01:56 Go to previous message
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

Report message to a moderator

Previous Topic: how to load two datafile into two tables by control file?
Next Topic: start oracle instance from command line
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 16 22:55:29 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.