Home » RDBMS Server » Server Utilities » IMPDP struck in 11g @ VIEW (oracle 11.2.0.3.0 - Windows server 2008 R2)
IMPDP struck in 11g @ VIEW [message #586138] Tue, 04 June 2013 01:16 Go to next message
muktha_22
Messages: 397
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 #586141 is a reply to message #586138] Tue, 04 June 2013 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Post the log
2/ Check there is space enough on your file system
3/ Query v$session to know why, where, on what it is waiting

Regards
Michel
Re: IMPDP struck in 11g @ VIEW [message #592524 is a reply to message #586141] Fri, 09 August 2013 07:24 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi, whether data-pump creates VIEW? how is that possible? we see the Datapump job running through help of DBA_DATAPUMP_JOBS, whether executing or not?

Re: IMPDP struck in 11g @ VIEW [message #592555 is a reply to message #592524] Fri, 09 August 2013 10:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This post is completely ununderstandable.
Is this a question? Is this an answer?

Regards
Michel
Re: IMPDP struck in 11g @ VIEW [message #592808 is a reply to message #592555] Mon, 12 August 2013 08:31 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: expdp VS RMAN backup
Next Topic: sql loader
Goto Forum:
  


Current Time: Sun Sep 21 21:35:56 CDT 2014

Total time taken to generate the page: 0.06716 seconds