dokuwiki

SQL

SQL> create directory filedir as '/u01/app/oracle/dbdir';

Directory created.

SQL> grant read, write on directory filedir to pbadmin;

SQL> create user pbadmin2 identified by mit;

User created.

SQL> grant create session, resource to pbadmin2; SQL> grant read, write on directory filedir to pbadmin2;

SQL> grant create session, resource to pbadmin2; SQL> grant unlimited tablespace to pbadmin2;

COMMAND LINE

$ expdp pbadmin/mit DUMPFILE=pbadmin.dmp DIRECTORY=filedir SCHEMAS=pbadmin

$ impdp pbadmin2/mit dumpfile=pbadmin.dmp directory=filedir remap_schema=pbadmin:pbadmin2