| Problem with EXPDP [message #351076] |
Mon, 29 September 2008 04:04  |
gokul_ifs
Messages: 41
Registered: March 2006
Location: india
|
Member |
|
|
Hi All,
I am trying to export full database dump using ORACLE datapump utility.
But I dont find the expdp command generating a dump from my database. Below I have listed the steps to i have followed.
C:\DB_Dump>sqlplus system@saas_per
SQL*Plus: Release 10.1.0.2.0 - Production on Mon Sep 29 14:29:11 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> grant read, write on directory exp_dir to saas_core;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
C:\DB_Dump>expdp saas_core@saas_per full=y directory=EXP_DIR dumpfile=SAAS_PERF_SEP29.dmp logfile=expdp_perf.log
Export: Release 10.1.0.2.0 - Production on Monday, 29 September, 2008 14:29
Copyright (c) 2003, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
C:\DB_Dump>
The expdp is not execute, it retuns to the dos prompt without should any error. The log file is also not generated.
Kindly help to solve this.
Thanks,
GOKUL
|
|
|
|
| Re: Problem with EXPDP [message #351085 is a reply to message #351076] |
Mon, 29 September 2008 04:29  |
gokul_ifs
Messages: 41
Registered: March 2006
Location: india
|
Member |
|
|
Hi,
To avoid version probelm, I tried to export by connecting to the DB server.
But I get the below mentioned errors,
[oracle@blrkecsaas1 ~]$ expdp system@saas full=y directory=EXP_DIR dumpfile=SAAS_PERF_SEP29.dmp logfile=expdp_perf.log
Export: Release 10.2.0.1.0 - Production on Monday, 29 September, 2008 14:34:22
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
Any idea about this??? Please help...
Thanks,
GOKUL
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
