Topic: Backup & Recovery >> Datapump
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Rajinikanth |
Posted: Mar 14, 2006 07:40:26 AM |
Total Post: 2
Joined: Mar, 2006
|
hi
i am trying to import a schema using impdp utility, i am getting following error, please help me.
this the command i executed
# impdp rajini1/rajini1@sales DIRECTORY=rajini dumpfile=EXPDAT01.DMP logfile=prd_imp_log.log
Import: Release 10.1.0.3.0 - Production on Monday, 13 March, 2006 22:25
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "/otb/prod_dir/EXPDAT01.DMP"
thanks
rajini.
|
|
|
 suprio |
| Posted: Mar 16, 2006 08:20:29 AM |  |
|
Total Post: 11
Joined: Sep, 2005
|
hi,
Its clearly saying that u have specifie a bad dump file name. As u know that datapump uses relative path rather that absolute path. so, u need to create a directory using create directory... command and then u must have read and write privilege on that directory.
i think this information must help out. Further problems are welcome.
suprio
|
|
|
|
|
| Rajinikanth |
| Posted: Apr 06, 2006 10:22:53 AM | |
|
Total Post: 2
Joined: Mar, 2006
|
Hi,
First of all thanks for the replay.
we find the problem the dump file is created with oracle version 10.0.2,but we are using oracle 10.0.1 this would not support we upgraded our oracle version and try it works fine
Thanks a lot for your effort.
rajini.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 387 |
| Vinoth Kumar | 379 |
| Gopu Gopi | 350 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
