Home » RDBMS Server » Server Utilities » Problem with EXPDP (Oracle 10g)
Problem with EXPDP [message #351076] Mon, 29 September 2008 04:04 Go to next message
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 Go to previous messageGo to next message
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
Re: Problem with EXPDP [message #351112 is a reply to message #351085] Mon, 29 September 2008 05:47 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-39070: Unable to open the log file.

Did you check physical directory path is exists or correct.?
Previous Topic: How to get a UNIX return code from RMAN in Solaris
Next Topic: another sql*loader doubt with excel sheet
Goto Forum:
  


Current Time: Sat Dec 10 16:37:09 CST 2016

Total time taken to generate the page: 0.09081 seconds