Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> data pump

data pump

From: Li Li <litanli_at_gmail.com>
Date: Fri, 17 Mar 2006 16:40:42 -0600
Message-ID: <5f35c2320603171440m3fa165eai18e90e8680ccff86@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 17 2006 - 16:40:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US