OraFAQ Forum: Server Utilities » ?expdp on 10gR2(10.2.0.1)

Home » RDBMS Server » Server Utilities » ?expdp on 10gR2(10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

?expdp on 10gR2(10.2.0.1) [message #173845]

Wed, 24 May 2006 16:01

cecilialeeus
Messages: 3
Registered: May 2006
Location: newark, ca

Junior Member

I always got "internal error" when invoking expdp:

expdp tp/tp DIRECTORY=/var/tmp/ DUMPFILE=hist.dmp TABLES=hist

Export: Release 10.2.0.1.0 - 64bit Production on Wednesday, 24 May, 2006 15:59:58

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not available

I was told that I should be able to use this utility as long
as the package is installed and "desc DBMS_DATAPUMP"
can return the tables setup:
SQL> desc DBMS_DATAPUMP
PROCEDURE ADD_DEVICE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
DEVICENAME VARCHAR2 IN
VOLUMESIZE VARCHAR2 IN DEFAULT
PROCEDURE ADD_FILE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
......

Can you please give me some pointers for this?

Thanks.

Report message to a moderator

Re: ?expdp on 10gR2(10.2.0.1) [message #173896 is a reply to message #173845]

Thu, 25 May 2006 02:59

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

You need to create and use a database directory!

SQL>  create directory dmpdir as '/var/tmp';
Directory created.

SQL> grant read, write on directory dmpdir to tp;
Grant succeeded.

Report message to a moderator

Re: ?expdp on 10gR2(10.2.0.1) [message #174093 is a reply to message #173896]

Thu, 25 May 2006 18:47

cecilialeeus
Messages: 3
Registered: May 2006
Location: newark, ca

Junior Member

yup, it worked. Smile

thanks!!

Report message to a moderator

Previous Topic:	how to export my tables in database
Next Topic:	import only source (procs, funcs, etc.)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 11:01:53 CST 2024