匯出資料庫的指令碼

[root@iptvdb ~]# su - oracle
-bash-3.2$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 24 10:36:29 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba             
Connected.
SQL> create directory exp as '/home/oracle/bak/base';

Directory created.

SQL> GRANT READ, WRITE ON DIRECTORY exp To sichuan020209test;

Grant succeeded.

root使用者登入，chmod 777 /oracle/key  授權

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
-bash-3.2$ expdp sichuan020209test/test201109 directory=exp content=metadata_only dumpfile=sichuan020209test.dmp logfile=sichuan020209test.log parallel=8
CREATE OR REPLACE DIRECTORY iptv AS  '/oracle/bakgina';
GRANT READ, WRITE ON DIRECTORY  iptv TO IPTV;
expdp ISA020209TEST/test201109 schemas=ISA020209TEST directory=iptv  content=all dumpfile=iptv_20111025%U.dump logfile=iptv_20111025.dump.log parallel=8

expdp iptv/certus20 schemas=IPTV directory=iptv dumpfile=iptv_20110312%U.dump logfile=iptv_20110312.dump.log parallel=8

Export: Release 10.2.0.1.0 - 64bit Production on Monday, 24 October, 2011 10:44:23

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SICHUAN020209TEST"."SYS_EXPORT_SCHEMA_01":  sichuan020209test/******** directory=exp content=metadata_only dumpfile=sichuan020209test.dmp logfile=sichuan020209test.log

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Master table "SICHUAN020209TEST"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SICHUAN020209TEST.SYS_EXPORT_SCHEMA_01 is:
  /home/oracle/bak/base/sichuan020209test.dmp
Job "SICHUAN020209TEST"."SYS_EXPORT_SCHEMA_01" successfully completed at 11:11:39

-bash-3.2$