Home » RDBMS Server » Server Utilities » Issue regarding IMPORT activity (Oracle 10g, Solaris 5.10)
Issue regarding IMPORT activity [message #490082] Thu, 20 January 2011 21:12 Go to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
Hi,
Our Testing DB is running in No archive log mode. I did a schema level import by dropping the existing user that contain tables, recreate the user and finished the import. Now they want the old tables back.

Is there is any way to recover the old tables? Can anybody help?
Re: Issue regarding IMPORT activity [message #490089 is a reply to message #490082] Thu, 20 January 2011 23:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is there is any way to recover the old tables?
Restore from previous backup.

>Can anybody help?
>I did a schema level import by dropping the existing user that contain tables,
In the future consider doing an export prior to drop; just in case old data is desired in the future.
Re: Issue regarding IMPORT activity [message #490090 is a reply to message #490089] Thu, 20 January 2011 23:13 Go to previous messageGo to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
Dear swan,
There is no backup available for the schema. Is there is any other way?
Re: Issue regarding IMPORT activity [message #490092 is a reply to message #490090] Thu, 20 January 2011 23:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
FLASHBACK?
are objects still in RECYCLEBIN?

chances for data recovery are slim to none.
Re: Issue regarding IMPORT activity [message #490095 is a reply to message #490092] Thu, 20 January 2011 23:28 Go to previous messageGo to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
Dear swan,
The DB is in no archive log mode. Is recover is possible by enabling it to archive now and then flashback database?
Re: Issue regarding IMPORT activity [message #490096 is a reply to message #490095] Thu, 20 January 2011 23:30 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is recover is possible by enabling it to archive now and then flashback database?
no

If you care about data in DB, then DB should ALWAYS run with archive mode enabled.
Previous Topic: Schema Export, table compares across schemas
Next Topic: Pre-requisite For Oracle Critical Patch Updates
Goto Forum:
  


Current Time: Thu Mar 28 11:27:45 CDT 2024