Web Development

Ask something
Discussion Locked

Export/Import in Oracle

0 helpful
4 replies

by eyad

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I export table from user like "scott" and import it in another user.

4 replies

by bill-beaton

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

by bill-beaton

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

This discussion is closed to new replies.