OraFAQ Forum: Server Utilities » Import Mistakes ....

Home » RDBMS Server » Server Utilities » Import Mistakes .... (10G)

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

Import Mistakes .... [message #481894]

Mon, 08 November 2010 02:37

setsuna
Messages: 32
Registered: November 2008

Member

Hi all expert,
I had made a stupid mistake by importing the data into the wrong schema.... To be exact, I had created import a schema called "DEV" into my own "SYS"..... And the problem is I did not even create a log file for tracing back.... haizz.... Will there be any impact to the DB due to this stupid mistake I had created.

IP/s: I do not wish to do recovery. Are there any other ssuggestions for me to clear up these imported data from my sys schema? What a careless bum I am Sad

Hope to hear from u guys soon....

Report message to a moderator

Re: Import Mistakes .... [message #481895 is a reply to message #481894]

Mon, 08 November 2010 02:40

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Manually delete everything you created. Log file could help; as you don't have it, create one - perform another import (into a dummy schema). Perhaps there's another, smarter way, but I don't know of any.

Report message to a moderator

Re: Import Mistakes .... [message #481901 is a reply to message #481894]

Mon, 08 November 2010 03:04

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And for the futur NEVER use SYS but for maintenance of the database (not the data).

Regards
Michel

Report message to a moderator

Re: Import Mistakes .... [message #481926 is a reply to message #481894]

Mon, 08 November 2010 08:01

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

You can do a

select * from user_objects order by created

in the SYS schema to show the new objects that were created.

This will help but may not be a 100% accurate representation but will help.

Report message to a moderator

Previous Topic:	expdp oracle directory and stays on defining never executing
Next Topic:	Exporting table structure from a particular DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:20:32 CST 2024