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
] 
Blog
Search
Help
Members
Register
Login
Home
