| Unable to import one procedure from full database dump ( 10g ) [message #328499] |
Fri, 20 June 2008 06:01  |
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 #337127 is a reply to message #328499] |
Wed, 30 July 2008 00:53  |
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 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
