Home » RDBMS Server » Server Utilities » Unable to import one procedure from full database dump ( 10g ) (oracle 10g rel 2 / sun solaris 5.9)
Unable to import one procedure from full database dump ( 10g ) [message #328499] Fri, 20 June 2008 06:01 Go to next message
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member
dear sir,

i have full export dump file....from this, i need to import only one procedure belongs to schema : IC_MIGR_DATA... i need to import into SCHEMA : rep_user...


iam giving syntax:

impdp system/icg0ld@ICPRD directory=DUMPDIR dumpfile=IC_FULL_19062008.dmp logfile=imp_IC_FULL_190608.log schemas=rep_user parfile=imp_proc.par

parfile :
--------
INCLUDE=PROCEDURE:"LIKE 'IC_MIGR_DATA.JET_UPLIFT'"


while importing, iam getting below error,

*****[oracle10@AIICDELL IC]$ impdp system/icg0ld@ICPRD directory=DUMPDIR dumpfile=IC_FULL_19062008.dmp logfile=imp_IC_FULL_190608.log schemas=rep_user parfile=imp_proc.par

Import: Release 10.2.0.2.0 - 64bit Production on Friday, 20 June, 2008 16:19:46

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-31644: unable to position to block number 30698425 in dump file "/AIIC_backup/expbkp/dumps/IC/IC_FULL_19062008.dmp"
******

pls cfm how to import this one procedure JET_UPLIFT , this has to be imported into REP_USER schema, owner of this procedure is IC_MIGR_DATA

THANK YOU
KESAVAN.
Re: Unable to import one procedure from full database dump ( 10g ) [message #328525 is a reply to message #328499] Fri, 20 June 2008 06:53 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-31644: unable to position to block number string in dump file "string"

Cause: Export or Import was unable to position its file pointer to a specific block within the dump file. This message is usually followed by device messages from the operating system.

Action: Take appropriate action based on the device messages.
Re: Unable to import one procedure from full database dump ( 10g ) [message #337127 is a reply to message #328499] Wed, 30 July 2008 00:53 Go to previous messageGo to next message
setisfai
Messages: 4
Registered: April 2008
Location: KL, Malaysia
Junior Member
Hi,

I am experiencing the same error while trying to run impdp as shown below:

-------------------------------------------------------------
[oracle@10GLIN64 20080713]$ impdp system/******* dumpfile=prod13july1_afeod1.dmp remap_schema=prod:azizi130708 directory=AZIZI_DMP_DIR

Import: Release 10.2.0.3.0 - 64bit Production on Tuesday, 29 July, 2008 17:37:23

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_FULL_04" failed to load/unload
ORA-31644: unable to position to block number 1996259 in dump file "/home/oracle/dmp/AZIZI/20080713/prod13july1_afeod1.dmp"
-------------------------------------------------------------

Before that, I already grant data pump directory to schema azizi130708 as follow:

GRANT READ,WRITE ON DIRECTORY AZIZI_DMP_DIR TO AZIZI130708;

If you manage to overcome this error, hopefully you could share with me the solution. Your kind help are highly appreciated.

Thanks you.
Re: Unable to import one procedure from full database dump ( 10g ) [message #487489 is a reply to message #328499] Tue, 28 December 2010 04:03 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

I am facing the same issue during the impdp.

I have already created directory and given read ,write permission on directory to user. but i m facing the same problem/error

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_TABLE_01" failed to load/unload
ORA-31644: unable to position to block number 6329955 in dump file "D:\AutomatedDbBackup\27dec\BACKUPMONETA161_20102712010500.DMP"


Kindly help

Regards

Pradeep
Re: Unable to import one procedure from full database dump ( 10g ) [message #487538 is a reply to message #487489] Tue, 28 December 2010 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Action: Take appropriate action based on the device messages.

Regards
Michel
Re: Unable to import one procedure from full database dump ( 10g ) [message #571433 is a reply to message #487538] Sun, 25 November 2012 23:55 Go to previous message
krunalvpatel
Messages: 1
Registered: November 2012
Location: UAE
Junior Member
Hi,

Please try to execute with below format. It will work.

impdp directory=BKP dumpfile=expdp_TEST_full_211112.dmp logfile=test_import_procedure.log schemas=TEST "INCLUDE=PROCEDURE:\"='POPULATE_SI_PIR_FORECAST'\""
Previous Topic: IMPDP hangs
Next Topic: SQL Laoder Date Handling
Goto Forum:
  


Current Time: Thu Mar 28 10:47:41 CDT 2024