Home » RDBMS Server » Server Utilities » Returning to this window.
Returning to this window. [message #253083] Sun, 22 July 2007 04:08 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I performed import data pump operation and it took a significant time to import. so I went to interactive mode and then press ctrl+C and exit from sqlplus. Now How I can inform now which row is being processed whenever I connect to it....

Import: Release 10.2.0.1.0 - Production on Sunday, 22 July, 2007 13:49:27

Copyright (c) 2003, 2005, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "PROD7"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "PROD7"."SYS_IMPORT_FULL_01":  prod7/******** directory=dimport dumpfile=dn01-20070716-1120am.dmp
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
;;; Import> help
;;; Import> status
;;; Import> continue_client
;;; Import> status
;;; Import> continue_client
;;; Import> exit_client
-bash-3.00$



Here is my import.log file..


I want to see my output like this like this...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Processing table  .......


I queried dba_datapump_jobs and its executing mode.


HOW I CAN KNOW WHICH OBJECT IS BEING PROCESSED NOW.

[Updated on: Sun, 22 July 2007 04:17]

Report message to a moderator

Re: Returning to this window. [message #253099 is a reply to message #253083] Sun, 22 July 2007 08:56 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Use the ATTACH keyword while launching EXPDP and then issue STATUS. For example,

expdp username/password ATTACH=<job_name>

<job_name> is optional if you only have one job running.
Previous Topic: SQL LODER - Single/Multiple csvs load Multiple tables
Next Topic: Exm/Imp Full Database
Goto Forum:
  


Current Time: Sat Dec 03 12:14:12 CST 2016

Total time taken to generate the page: 0.12155 seconds