Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

wrong import

R. RoyalOct 3 2012 — edited Oct 4 2012
Hi,
Oracle version 11.2.0
I've the dmp file with owner=TOM

I imported dmp file with wrong sintax:
imp system/pwd@sid fromuser=TOM touser=system file=myimport.dmp log=myimport.log


Now the owner TOM's objects is system but I need import again the dmp file with correct owner:
imp system/pwd@sid fromuser=TOM touser=TOM file=myimport.dmp log=myimport.log

All TOM's objects are imported into tablespace system with owner system, How can I delete these objects from system and import it correctly?


Thanks in advance!

Comments

saurabh
you need to drop all the objects belonging to tom manually. you can do is
imp user/password file=file.dmp log=logfile.log show=y
This is the dummy import it will not actually import the data instead it will display all the sql statements that will be executed will importing the dump file. Then using these information you can delete the tables and all object belonging to tom.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 1 2012
Added on Oct 3 2012
#database-key-features, #export-import-sql-loader-external-tables
1 comment
141 views