Oracle Database/Dump

Oracle Database/Dump


If it was exported using exp and a full schema was exported, then

// create the user
create user <username> identified by <password> default tablespace <tablespacename> quota unlimited on <tablespacename>;

//Grant the rights:
grant connect, create session, imp_full_database to <username>;

// Start the import with imp:
imp <username>/<password>@<hostname> file=<filename>.dmp log=<filename>.log full=y;

If it was exported using expdp, then start the import with impdp:

impdp <username>/<password> directory=<directoryname> dumpfile=<filename>.dmp logfile=<filename>.log full=y;

Last update: 2020-09-25 08:54:44 UTC