Home » RDBMS Server » Server Utilities » IMPDP ---- big table's data can't be imported .hope for resolve!! (oracle 10g R2,AIX 6.1)
icon4.gif  IMPDP ---- big table's data can't be imported .hope for resolve!! [message #599369] Wed, 23 October 2013 23:51 Go to next message
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!!
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 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
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.
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
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.
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 Go to previous messageGo to next message
Lucien.Young
Messages: 7
Registered: October 2013
Junior Member
./fa/11184/0/

THX BUDDY

This is the problem I have met.Have you ever seen it before?
  • Attachment: 截图00.jpg
    (Size: 145.02KB, Downloaded 378 times)
icon5.gif  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 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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)?

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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
are there any clues in logfile=impdp_szdb.log
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
ThomasG
Messages: 3099
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.
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 Go to previous messageGo to next message
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!!!!!
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 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
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/
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 Go to previous message
John Watson
Messages: 4569
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?
Previous Topic: exp failed in 11.2.0.3
Next Topic: Run Exp utility in background mode
Goto Forum:
  


Current Time: Sat Sep 20 15:17:53 CDT 2014

Total time taken to generate the page: 0.09520 seconds