ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;
GRANT CONNECT,DBA,RESOURCE TO scott;
NOAUDIT ALL;
DROP TABLE SYS.AUD$ PURGE;
COMMIT;
@/opt/db/app/oracle/11g/javavm/install/rmjvm.sql
@/opt/db/app/oracle/11g/rdbms/admin/catexp.sql
@/opt/db/app/oracle/11g/rdbms/admin/catproc.sql
@/opt/db/app/oracle/11g/rdbms/admin/utlrp.sql
COMMIT;
CREATE OR REPLACE DIRECTORY datapump AS '/work/datapump/';
GRANT READ, WRITE ON DIRECTORY datapump TO scott;
expdp scott/tiger full=y directory=datapump dumpfile=full.dmp
impdp scott/tiger full=y directory=datapump dumpfile=full.dmp