Home » RDBMS Server » Server Utilities » question on data pump
question on data pump [message #204686] Tue, 21 November 2006 12:49 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
I have a question on datapump export utility


What is the SYS_EXPORT_SCHEMA_01 table when the datapump export is started.
below is the extract of the log file

==========
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": SYSTEM/******** SCHEMAS=hr
DIRECTORY=dmpdir DUMPFILE=schema.dmp REMAP_SCHEMA=hr:hrdev
EXCLUDE=constraint, ref_constraint, index TABLE_EXISTS_ACTION=replace LOGFILE=impschema.log
==========

is it a temporary table? What does this table SYS_EXPORT_SCHEMA_01 table do? does it get cleared once the export is done.

Thanks
Re: question on data pump [message #204730 is a reply to message #204686] Tue, 21 November 2006 22:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi ravi,


SYS_EXPORT_SCHEMA_01

Above is name of the import or export operation JOB NAME after ur import or export is start you can find how much is done or how much is remaining.

like

DBA_DATAPUMP_JOBS
This view will show the active Data Pump jobs, their state, degree of parallelism, and the number of sessions attached. 


SQL> select * from dba_datapump_jobs

OWNER_NAME JOB_NAME               OPERATION  JOB_MODE   STATE         DEGREE    ATTACHED_SESSIONS
---------- ---------------------- ---------- ---------- ------------- --------- -----------------
JKOOP      SYS_EXPORT_FULL_01     EXPORT     FULL       EXECUTING     1          1
JKOOP      SYS_EXPORT_SCHEMA_01   EXPORT     SCHEMA     EXECUTING     1          1


http://orafaq.com/comment/reply/67




hope this helps
Taj.
Re: question on data pump [message #205193 is a reply to message #204686] Thu, 23 November 2006 18:22 Go to previous message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
Thanks so much. That was very helpful. Thanks for the link. That was very informative.

Regards
Ravi
Previous Topic: How to use SQL Loader
Next Topic: How to trim newlineChar,blanks on columns
Goto Forum:
  


Current Time: Wed Dec 07 06:27:27 CST 2016

Total time taken to generate the page: 0.13079 seconds