| IMPDP struck in 11g @ VIEW [message #586138] |
Tue, 04 June 2013 01:16  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hello All,
I am trying to upgrading my database,
step1:
Created Database and relevant Tablesapaces in a 11g Db circumstance.
step2:
While importing schema through Datapump, The import getting hanged up at the stage of VIEW.
Kindly help me out on this.
impdp system/******* SCHEMAS=BKPUSR,CAB,LIVE,NEW,REPO DIRECTORY=EXPBKUP DUMPFILE=NEWGEN_Export_03-jUN-13.dmp LOGFILE=NEWGEN_03-06-2013.log
Regards
Muthu
|
|
|
|
|
|
|
|
|
|
| Re: IMPDP struck in 11g @ VIEW [message #592808 is a reply to message #592555] |
Mon, 12 August 2013 08:31  |
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
|
Senior Member |
|
|
Hello Michael Sir,
Iam Sorry for my way of questioning,as iam a begineer to this field, iam just learning things from people through forum, whenever a datapump job running, a table with the job name will be created and will be deleted once the job is over,for example, SYS_EXPORT_XXXX_01. Oracle understands that job is running through the table created,
am i correct ?
With Thanks,
Yours Sincerely,
Rajagopal S.
|
|
|
|
| Re: IMPDP struck in 11g @ VIEW [message #592817 is a reply to message #592808] |
Mon, 12 August 2013 08:54 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Yes and no.
There is a row in the table giving the status.
But there is also a X$ table for the running data pump jobs.
Have a look at the definition of DBA_DATAPUMP_JOBS view, the question is answered there.
Regards
Michel
[Updated on: Mon, 12 August 2013 08:55] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
