| IMP Datapump error [message #391606] |
Thu, 12 March 2009 12:57  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello All,
I did expdp on production and trying to impdp into test environment for refresh .
The export datapump was successful but after moving the file to the test environment , when I'm trying to import I'm getting the below error :
[oracle@usfldbd7 export]$ impdp system/me3taud1t parfile=salep1_salepoint2_mar12.par
Import: Release 10.2.0.3.0 - 64bit Production on Thursday, 12 March, 2009 13:42:45
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, Oracle Label Security, OLAP and Data Mining Scoring Engine options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/opt/oracle/data/SALET01/dpump/salep1_salepoint2_mar12.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3.
And these are the contents in my parfile :
directory=dpump
dumpfile =salep1_salepoint2_mar12.dmp
schemas=SALEPOINT2
logfile=salep1_salepoint2_mar12.log
I have created the directory dpump in test and gave the permissions also . But still the same .
Can somebody help me where I'm wrong .
Regards,
Raj
|
|
|
|
|
|
|
|
|
|
|
|
| Re: IMP Datapump error [message #391612 is a reply to message #391610] |
Thu, 12 March 2009 13:10  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Yes ,
We used expdp only for export . When I give ls -ls , I get
-rw-r--r-- 1 oracle dba 15248666624 Mar 12 07:33 salep1_salepoint2_mar12.dmp
-rw-r--r-- 1 oracle dba 24194 Mar 12 07:30 salep1_salepoint2_mar12.log
Edit: Mahesh Rajendran
Added CODE tags.
[Updated on: Thu, 12 March 2009 13:20] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: IMP Datapump error [message #391620 is a reply to message #391618] |
Thu, 12 March 2009 13:36 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
The below was the syntax , i used to expdp
expdp system/*** parfile=abc.par
abc.par
directory= DATA_PUMP_DIR
dumpfile= salep1_salepoint2_mar12.dmp
SCHEMAS=SALEPOINT2
logfile= salep1_salepoint2_mar12.log
exclude=statistics
Flashback_scn=5046872170694
And after that ftp the file in binary mode . Created dpump directory and gave the permission and impdp the file as
impdp system/*** parfile=abc.par
abc.par=
directory=dpump
dumpfile=salep1_salepoint2_mar12.dmp
logfile=salep1_salepoint2_mar12.log
schemas=salepoint2
Is there anything wrong in the syntax , please let me know .
Or if you can send me the syntax , I can do it once again.
[Updated on: Thu, 12 March 2009 13:38] Report message to a moderator |
|
|
|
|
|
| Re: IMP Datapump error [message #391622 is a reply to message #391621] |
Thu, 12 March 2009 13:50 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
I did drop that directory and re-created a new one and did the import again as
SQL> create directory dpump as '/opt/oracle/db/rdbms/log/dpump';
Directory created.
SQL> grant READ, WRITE ON DIRECTORY dpump to SALEPOINT2;
Grant succeeded.
[oracle@usfldbd7 data]$ impdp system/me3taud1t dumpfile=salep1_salepoint2_mar12.dmp logfile=salep1_salepoint2_mar12.log schemas=salepoint2 directory=dpump
Import: Release 10.2.0.3.0 - 64bit Production on Thursday, 12 March, 2009 14:32:55
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, Oracle Label Security, OLAP and Data Mining Scoring Engine options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/opt/oracle/db/rdbms/log/salep1_salepoint2_mar12.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
---------- -------------------- ------------------------------
SYS DPUMP /opt/oracle/db/rdbms/log/dpump
And while FTP , I use bin and did the FTP .
|
|
|
|
|
|
| Re: IMP Datapump error [message #391624 is a reply to message #391623] |
Thu, 12 March 2009 14:00 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
No need to grant the permission to salepoint2 schema?
And we did the expdp with system schema only .
mahesh ,
Is the above syntax in any manner ?
If it's wrong please tell me how to follow it for now.
|
|
|
|
|
|
| Re: IMP Datapump error [message #391631 is a reply to message #391627] |
Thu, 12 March 2009 14:24 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Mahesh,
So for a final recap , the syntax will look like :
impdp salepoint2/*** dumpfile=salelpoint.dmp logfile=salepoint.log directory=dpump schemas=salepoint2
Is the above syntax OK .
And should I be in the same directory as dpump and move the dumpfile to that directory and do the IMPDP.
please let me know.
|
|
|
|
|
|
|
|
|
|
| Re: IMP Datapump error [message #391644 is a reply to message #391635] |
Thu, 12 March 2009 15:46 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hi all,
The impdp works well now. Thanks again to all of you for your time on this. The object count of both production and test are correct but in the test I got the below error :
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'SALEP_TO_ILOG' does not exist
Failing sql is:
GRANT SELECT ON "SALEPOINT2"."TRENDWEST_MF_CONTRACTS_V" TO "SALEP_TO_ILOG"
What does it indicate
The specified role is not even there in the production box also.
[Updated on: Thu, 12 March 2009 15:50] Report message to a moderator |
|
|
|
|
|
| Re: IMP Datapump error [message #391652 is a reply to message #391646] |
Thu, 12 March 2009 16:09 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Yes Mahesh , it's a user in prodution. But the object count in Prod and Test is the same for that schema .
So , you mean to say the IMPDP has gone wrong somewhere ?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
