Skip to Main Content

Oracle Database Discussions

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!

imp command

user11221081May 24 2011 — edited May 24 2011
hello guys

i have exported from one user ,now i need to import into another user

so i want the command for the same as i think i need to import with sys user so i am mistaking somewhere in codes.

imp 'sys / as sysdba' file=x.dmp tables=x fromuser=a touser=b

my os is RHEL 5 and database 10.2.0.4

i need the command imp not impdp
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2011
Added on May 24 2011
5 comments
1,143 views