Export Database scripts

[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,200 5, 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 User Logon, chmod 777/oracle/key authorization

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 sichuan0209test/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,200 5, 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". "initialize": sichuan020209test/******* directory = exp content = metadata_only dumpfile = sichuan020209test. dmp logfile = sichuan0209test. log.

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION
Processing object type SCHEMA_EXPORT/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 $