Home » RDBMS Server » Server Utilities » EXDP ERROR (10g AIX)
EXDP ERROR [message #314649] Thu, 17 April 2008 06:41 Go to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
hello
i have scripts like that:
"$ORACLE_HOME/bin/expdp system/e34rcufx full=y directory=ora_export dumpfile=EX
PWMSDAILY$DATE_FORMAT.dmp logfile=EXPWMSDAILY$DATE_FORMAT.log"

its do the exp
i see files in my directory:

-rw---- 1 leiman helios 482099200 Apr 16 20:01 EXPWMSDAILY3.dmp
-rw-rw-r-- 1 leiman helios 467 Apr 16 23:00 EXPWMSDAILY3.log


but in log i see that error: why?

With the Partitioning, OLAP and Data Mining options
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/ora_export/EXPWMSDAILY3.dmp"
ORA-27038: created file already exists
Additional information: 1

thanks
Re: EXDP ERROR [message #314652 is a reply to message #314649] Thu, 17 April 2008 06:53 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
i dont understand .

why i see one file in 20:00
and log at 23:00

the EXP its just few mintues
Re: EXDP ERROR [message #314664 is a reply to message #314652] Thu, 17 April 2008 07:35 Go to previous message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

this is the first time you are taking the dumpfile using the datapump ?

if you already taken and now trying for the second time means it will throw error that the ORA-27038: created file already exists


Gopu
Previous Topic: Full Import error
Next Topic: Upgradation 9i R2 to 10g R2
Goto Forum:
  


Current Time: Tue Dec 24 23:29:16 CST 2024