Home » RDBMS Server » Server Utilities » Impdp issue (merged) (10g Release 2 Unix)
Impdp issue (merged) [message #681162] Mon, 22 June 2020 05:07 Go to next message
satishs1
Messages: 2
Registered: June 2020
Junior Member
Hi Team,

I have successfully exported table but while improting not getting any error session going to close. Please help me to fix this issue.

;;;
Import: Release 10.2.0.5.0 - 64bit Production on Monday, 22 June, 2020 15:28:50

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
impdp issue [message #681164 is a reply to message #681162] Mon, 22 June 2020 05:31 Go to previous messageGo to next message
satishs1
Messages: 2
Registered: June 2020
Junior Member
Hi Team,

I have successfully exported a table but while importing table the session closing without error. Below are the details.

rcqtcl:orarcq 41> impdp Admin tables=SAPR3P.RFCDES directory=Backup_RFC dumpfile=SAPR3P_RFCDES.dmp logfile=imp_SAPR3P_RFCDES.log table_exists_action=replace

Import: Release 10.2.0.5.0 - 64bit Production on Monday, 22 June, 2020 15:28:50

Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

rcqtcl:orarcq 42>


Could you please help me to fix this issue.
Re: impdp issue [message #681171 is a reply to message #681164] Mon, 22 June 2020 08:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what clues exist within logfile=imp_SAPR3P_RFCDES.log
Re: Impdp issue (merged) [message #681172 is a reply to message #681162] Mon, 22 June 2020 09:49 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The result should be something like:
>impdp Admin tables=SAPR3P.RFCDES directory=Backup_RFC dumpfile=SAPR3P_RFCDES.dmp \
 logfile=imp_SAPR3P_RFCDES.log table_exists_action=replace

Import: Release 10.2.0.5.0 - Production on Lundi, 22 Juin, 2020 16:43:49

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Password:
That is, more likely impdp is waiting for you to enter a password.
I bet your tty was in bad mood.
Try "stty sane" before your impdp.

Previous Topic: SQL LOADER in shell script
Next Topic: EXPDP fails returning "ORA-31626: job does not exist"
Goto Forum:
  


Current Time: Thu Mar 28 09:33:46 CDT 2024