General discussion

Locked

Export/Import in Oracle

By Eyad ·
How can I export table from user like "scott" and import it in another user.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Export/Import in Oracle

by bill-beaton In reply to Export/Import in Oracle

Kind of like this ... assume your file is xxx.dmp, and the instance you're importing to is MYORCL; then
1. ensure that the ORACLE_SID=MYORCL
2. If you have the dba password, such as sys/manager then:

imp sys/manager file=xxx.dmp fromuser=scott touser=myuser

The above has to be done also if a dba created the export file.

if the file was ctreated by scott user, then
...

imp newuser/newuserpassword file=xxx.dmp

Collapse -

Export/Import in Oracle

by bill-beaton In reply to Export/Import in Oracle

I forgot above ...
for scott to export, then
exp scott/scottpassword file=xxx.dmp

for dba to export, then
exp sys/manager file=xxx.dmp owner=scott

Collapse -

Export/Import in Oracle

by Eyad In reply to Export/Import in Oracle

Poster rated this answer

Collapse -

Export/Import in Oracle

by Eyad In reply to Export/Import in Oracle

This question was closed by the author

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums