OraFAQ Forum: Server Utilities » IMPDP ---- big table's data can't be imported .hope for resolve!!

Home » RDBMS Server » Server Utilities » IMPDP ---- big table's data can't be imported .hope for resolve!! (oracle 10g R2,AIX 6.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599369]

Wed, 23 October 2013 23:51

Lucien.Young
Messages: 7
Registered: October 2013

Junior Member

HELLO GUYS!
This morning,I was running IMPDP for my company's database.Everything is just fine except one problem.A big table(61.1G) could't be imported.The warning message shows "imported TBL_XXXX 61.1G 0 out of 147653981rows".The alert log had no warning message.I didn't know
where was wrong and how to resolve it.Hope for you guys can help me!!!Thx!!

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599370 is a reply to message #599369]

Wed, 23 October 2013 23:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You have a problem.
So why are you attempting to impdp a 61.1G table?
I suspect you have a disk space problem; but root cause could be due to numerous different reasons.

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599371 is a reply to message #599370]

Thu, 24 October 2013 00:11

Lucien.Young
Messages: 7
Registered: October 2013

Junior Member

This table is our customer's data.I need to import it to my test environment for our online testing.Data size is fixed and my disk capacity is big enough ,also my tablespace capacity.

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599372 is a reply to message #599371]

Thu, 24 October 2013 00:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Lucien.Young wrote on Wed, 23 October 2013 22:11

This table is our customer's data.I need to import it to my test environment for our online testing.Data size is fixed and my disk capacity is big enough ,also my tablespace capacity.

so why did the impdp fail?

we only know what you post.

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599374 is a reply to message #599372]

Thu, 24 October 2013 00:20

Lucien.Young
Messages: 7
Registered: October 2013

Junior Member

THX BUDDY

This is the problem I have met.Have you ever seen it before?

Attachment: 截图00.jpg
(Size: 145.02KB, Downloaded 4591 times)

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599382 is a reply to message #599374]

Thu, 24 October 2013 01:12

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is there any VPD policy on the table?
Did you export the rows of this table?
What is your complete impdp command (including the parameter file if you used one)?

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599384 is a reply to message #599382]

Thu, 24 October 2013 01:23

Lucien.Young
Messages: 7
Registered: October 2013

Junior Member

no guys, this is just a simple data table,it has no special data.
And, I'm pretty sure I have exported this table from our user database.
The following sentence is my impdp order:
impdp linc directory=DUMPDIR dumpfile=expdp_szdb_%U.dmp logfile=impdp_szdb.log parallel=3

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599508 is a reply to message #599384]

Thu, 24 October 2013 22:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

are there any clues in logfile=impdp_szdb.log

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599511 is a reply to message #599508]

Thu, 24 October 2013 23:22

Lucien.Young
Messages: 7
Registered: October 2013

Junior Member

No man , not at all.The log file is just as same as the screen shows.I have no clue for this problem.

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599538 is a reply to message #599511]

Fri, 25 October 2013 09:01

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

OK, probably a "silly question", but have you checked if there ARE any rows in the table or not now?

Because the "0 out of ...." rows message looks like the one that is shown when the import for the table starts, so *maybe* it's just a glitch in the writing to the log file.

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599557 is a reply to message #599538]

Fri, 25 October 2013 20:06

Lucien.Young
Messages: 7
Registered: October 2013

Junior Member

ThomasG wrote on Fri, 25 October 2013 09:01

OK, probably a "silly question", but have you checked if there ARE any rows in the table or not now?

Because the "0 out of ...." rows message looks like the one that is shown when the import for the table starts, so *maybe* it's just a glitch in the writing to the log file.

Thanks my friend,it's just like some kind of joke.
There has no rows in this table now,and I have checked this situation for 1,000 times.I Dropped table and have another try,sadly it happened again.Holyyy!!!!!

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599558 is a reply to message #599557]

Fri, 25 October 2013 20:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I Dropped table and have another try,sadly it happened again.
We are NOT standing behind you & have no idea what exactly you did or what exactly you saw.

You are reporting an observation that you do not understand & imply that you think something else should be reported.
We don't know if you or Oracle are mistaken.
If Oracle is mis-reporting reality, then you need to file a Bug Report.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599565 is a reply to message #599557]

Sat, 26 October 2013 02:23

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

What happens when you try to import just that one table? With an appropriate value for the TABLE_EXISTS_ACTION clause? Can you use the CONTENT clause to create the table, and then again to bring in the rows?

Report message to a moderator

Previous Topic:	exp failed in 11.2.0.3
Next Topic:	Run Exp utility in background mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 14 21:18:09 CDT 2026