Home » RDBMS Server » Server Utilities » Import Mistakes .... (10G)
icon4.gif  Import Mistakes .... [message #481894] Mon, 08 November 2010 02:37 Go to next message
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....

Re: Import Mistakes .... [message #481895 is a reply to message #481894] Mon, 08 November 2010 02:40 Go to previous messageGo to next message
Littlefoot
Messages: 21687
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.
Re: Import Mistakes .... [message #481901 is a reply to message #481894] Mon, 08 November 2010 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And for the futur NEVER use SYS but for maintenance of the database (not the data).

Regards
Michel
Re: Import Mistakes .... [message #481926 is a reply to message #481894] Mon, 08 November 2010 08:01 Go to previous message
joy_division
Messages: 4950
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.
Previous Topic: expdp oracle directory and stays on defining never executing
Next Topic: Exporting table structure from a particular DB
Goto Forum:
  


Current Time: Fri Sep 17 08:05:53 CDT 2021