Re: Urgent: Accidentally dropped tables

I work for a company who specialise in this type of 'internal' recovery. Providing the data files have not been modified since the drop we are able to recover all of your data. Shutdown the database and a take a full clean backup.

Drop me a line.

Steve

Atif wrote in message <7fcn4s$3nh$1_at_nnrp1.dejanews.com>...
>I accidentally dropped the most important tables in my schema.
>It is next to impossible to get all the valuable data back.
>From what I have read so far, it seems that I can only recover
>my tables back if Oracle was running in archive log mode.
>
>The only way I know how to check if it is. is by typing :
>
>SVRMGR> archive log list
>Database log mode No Archive Mode
>Automatic archival Disabled
>Archive destination ?/dbs/arch
>Oldest online log sequence 0
>Current log sequence 1
>
>From this it doesn't seem that my database wasn't running in
>ARCHIVELOG mode. Is this a safe assumption? Does Oracle not
>run in ARCHIVELOG made by default.
>
>Do the rollback segments not record all the changes being made
>to the database? Can these be somehow used to construct my
>tables back?
>
>And I didn't have backup on tape etc. Is there any way to get
>my tables back?
>
>Thanks a million in advance.
>
>atif55_at_my-dejanews.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 20 1999 - 11:37:08 CDT