OraFAQ Forum: Server Utilities » question on data pump

Home » RDBMS Server » Server Utilities » question on data pump

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

question on data pump [message #204686]

Tue, 21 November 2006 12:49

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

Report message to a moderator

Re: question on data pump [message #204730 is a reply to message #204686]

Tue, 21 November 2006 22:15

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.

Report message to a moderator

Re: question on data pump [message #205193 is a reply to message #204686]

Thu, 23 November 2006 18:22

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

Report message to a moderator

Previous Topic:	How to use SQL Loader
Next Topic:	How to trim newlineChar,blanks on columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 13:44:24 CDT 2024