Revision [3751]

Last edited on 2010-07-13 02:55:16 by KenFong
Additions:
===Check datapump status===
SYS@xxxxx1> select * from dba_datapump_jobs
SYS@xxxxx1> select username,opname,target_desc,sofar,totalwork,message from V$SESSION_LONGOPS where username = 'SYSTEM';
USERNAME
------------------------------
OPNAME
----------------------------------------------------------------
TARGET_DESC SOFAR TOTALWORK
-------------------------------- ---------- ----------
MESSAGE
--------------------------------------------------------------------------------
SYSTEM
SYS_EXPORT_FULL_01
EXPORT 0 142
SYS_EXPORT_FULL_01: EXPORT : 0 out of 142 MB done

Revision [2269]

Edited on 2009-04-06 23:44:22 by WikiAdmin
Additions:
=== Export ===
==Full export/import==
exp system/blah full=Y consistent=y feedback=2000 file=165dump.dat log=165dump.log
imp system/blah FULL=y FIlE=165dump.log log=165dump.implog
Deletions:
=== Exporting ===

Revision [1521]

Edited on 2008-03-20 02:03:52 by WikiAdmin
Deletions:
{{adsense}}

Revision [1520]

Edited on 2008-03-20 02:03:34 by WikiAdmin
Additions:
Note that directory is actually referring to directory objets in oracle. So you will find the following command handy:
create or replace directory dump_dir as '/home/oracle/dumps';

Revision [1519]

Edited on 2008-03-20 00:46:16 by WikiAdmin
Additions:
===DataPump===
From 10g onwards, Oracle adds the datapump facilities to perform export and import.
expdp dba/2008db dumpfile=nco20080320.dmp directory=dump_dir schemas=nco

Revision [140]

Edited on 2007-04-14 21:31:47 by WikiAdmin
Additions:
{{parent page="Oracle"}}

Revision [87]

The oldest known version of this page was created on 2007-04-14 09:30:53 by WikiAdmin
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki