Table of Contents
expdp -- is the dump of the future. In order to successfully run expdp I had to do the following steps:-
CREATE DIRECTORY dumplocation '/home/oracle/dumpfile/' ; GRANT read, write on dumplocation to mhg; ALTER user mhg TEMPORARY TABLESPACE temp ; At this point I was getting the error ORA-25153: Temporary Tablespace is Empty ALTER tablespace temp add datafile 200M ; At this point I issued the command expdp directory=dumplocation Export: Release 10.1.0.2.0 - Production on Friday, 05 November, 2004 19:47 Copyright (c) 2003, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options FLASHBACK automatically enabled to preserve database integrity. Starting "MHG"."SYS_EXPORT_SCHEMA_04": mhg/********@test directory=dumplocation Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 576 KB Processing object type SCHEMA_EXPORT/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA 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 . . exported "MHG"."SYS_EXPORT_SCHEMA_01" 84.57 KB 810 rows . . exported "MHG"."SYS_EXPORT_SCHEMA_02" 84.57 KB 810 rows . . exported "MHG"."SYS_EXPORT_SCHEMA_03" 84.57 KB 810 rows .............................................