data pump
- From: "Li Li" <litanli@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 17 Mar 2006 16:40:42 -0600
Hi, All
I am trying to use data pump to export the whole database (db version
10.1.0.4). Here is what I have done:
1. login sys as sysdba and created the directory as follows:
create directory dumpdir as 'D:\dbback\orcl\export';
grant read, write on directory dumpdir to system;
2. run expdp as follows:
expdp system/password full=y directory=dumpdir dumpfile=full_exp.dmp
job_name=full_exp logfile=full_exp.log
then expdp just hang up, log is as follows:
Export: Release 10.1.0.4.0 - Production on Friday, 17 March, 2006 16:14
Copyright (c) 2003, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Release 10.1.0.4.0 - Production
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."FULL_EXP": system/******** full=y directory=dumpdir
dumpfile=full_exp.dmp job_name=full_exp logfile=full_exp.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64.18 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/DE_SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/DE_S_SEQ_OWNER_OBJGRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/DE_PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type
DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type
DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/CLUSTER/CLUSTER
Processing object type DATABASE_EXPORT/SCHEMA/CLUSTER/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Any thoughts? TIA
Other related posts:
