Home » RDBMS Server » Server Utilities » find the data after drop table
find the data after drop table [message #71405] Tue, 29 October 2002 10:47 Go to next message
alaa mostafa
Messages: 5
Registered: October 2002
Junior Member
If i drop a table,and commit, can i find the table data or not
alaa

Report message to a moderator

Re: find the data after drop table [message #71406 is a reply to message #71405] Tue, 29 October 2002 11:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
after dropping the table ,
what are u commiting to?
DROP table is a DDL. an implicit COMMIT would
be issued.
eventually, whether u commit or not, your table is gone.

Report message to a moderator

Re: find the data after drop table [message #71408 is a reply to message #71405] Tue, 29 October 2002 20:32 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Sure. The data will be still on the hard drives where you stored. It's not actually removed, just the OS block pointers are removed. If you can read bites and link them, then you can find it.

In your last backup the data will be there too. :-))

Now, seriously..

If you have 9i, and you configured flashback feature - then the data will be in your undo segments. Setup the flashback of the time of dropping and you will see your data.

You can use LogMiner too, to restore the dropped data as well.

Report message to a moderator

Previous Topic: Import Data
Next Topic: Two challenges with the SQL*Loader tool
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 13 16:14:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.