OraFAQ Forum: Server Utilities » Issue regarding IMPORT activity

Home » RDBMS Server » Server Utilities » Issue regarding IMPORT activity (Oracle 10g, Solaris 5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue regarding IMPORT activity [message #490082]

Thu, 20 January 2011 21:12

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?

Report message to a moderator

Re: Issue regarding IMPORT activity [message #490089 is a reply to message #490082]

Thu, 20 January 2011 23:09

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.

Report message to a moderator

Re: Issue regarding IMPORT activity [message #490090 is a reply to message #490089]

Thu, 20 January 2011 23:13

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?

Report message to a moderator

Re: Issue regarding IMPORT activity [message #490092 is a reply to message #490090]

Thu, 20 January 2011 23:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

FLASHBACK?
are objects still in RECYCLEBIN?

chances for data recovery are slim to none.

Report message to a moderator

Re: Issue regarding IMPORT activity [message #490095 is a reply to message #490092]

Thu, 20 January 2011 23:28

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?

Report message to a moderator

Re: Issue regarding IMPORT activity [message #490096 is a reply to message #490095]

Thu, 20 January 2011 23:30

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.

Report message to a moderator

Previous Topic:	Schema Export, table compares across schemas
Next Topic:	Pre-requisite For Oracle Critical Patch Updates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 05:55:34 CDT 2023