Home » RDBMS Server » Server Utilities » impdp error (Oracle 10.2.0.3 Linux AS4)
impdp error [message #397685] Mon, 13 April 2009 06:45 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello ,

I'm trying to do import using datapump .
I gave user/pass parfile=abc.par

But the import hangs and nothing moves and it's been more than 3 hours that nothing moves on and I found error in the alert.log as:
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=15, OS id=428
         to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_SCHEMA_10', 'SYSTEM', 'KUPC$C_1_20090413024450', 'KUPC$S_1_20090413024450', 0);
kupprdp: worker process DW01 started with worker id=1, pid=17, OS id=2168
         to execute - SYS.KUPW$WORKER.MAIN('SYS_IMPORT_SCHEMA_10', 'SYSTEM');


For this they gave in the Metalink doc : 455021.1 as it's a bug and can be ignored .

Not knowing what to do . Any help on this please.

Raj
Re: impdp error [message #397689 is a reply to message #397685] Mon, 13 April 2009 06:50 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>For this they gave in the Metalink doc : 455021.1 as it's a bug and can be ignored .

Thanks.

This is NOT error message. You can ignore.

>>But the import hangs and nothing moves and it's been more than 3 hours that nothing moves on and I found error in the alert.log as:

Post your import command and parfile.

Post your complete logfile.

Babu


[Updated on: Mon, 13 April 2009 06:52]

Report message to a moderator

Re: impdp error [message #397692 is a reply to message #397685] Mon, 13 April 2009 07:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>it's been more than 3 hours that nothing moves on

How much volume of data (and indexes) are we talking about?
It could be just me chugging, slowly.

[Updated on: Mon, 13 April 2009 07:04]

Report message to a moderator

Re: impdp error [message #397693 is a reply to message #397689] Mon, 13 April 2009 07:02 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Below is the content of the parfile:

impdp user/pass parfile=imp.par

imp.par=LOGFILE=import_bistg.log
DIRECTORY=EXPORT_DIR
DUMPFILE=export_bistg_%U.dmp
SCHEMAS=(BIREAD,BISTG)


And attached is the content of my import log file.

Raj

  • Attachment: impdp.log
    (Size: 6.90KB, Downloaded 252 times)
Re: impdp error [message #397695 is a reply to message #397692] Mon, 13 April 2009 07:08 Go to previous message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
The data is around 70 Gb . In the mor'g I did for one database and it took 2 hours and completed . But this database on the same server I started at 2.45 EST and now it is 8.00 EST and still it hangs .

The data has been imported but it hangs at

. . imported "BIREAD"."QUEST_SX_PLAN1"                       0 KB       0 rows
. . imported "BISTG"."INVOICE"                               0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX


Help on this will be thankful a lot
Previous Topic: INFILE path of SQL LOADER
Next Topic: Import a 10g dmp file from 9i
Goto Forum:
  


Current Time: Sat Dec 10 20:21:20 CST 2016

Total time taken to generate the page: 0.08725 seconds