OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Export problem

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

Export problem [message #250522]

Tue, 10 July 2007 06:07

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

Hi to all

Oracle 10g release 1
with
linex fc4 version

----Problem occur during exporting full database.------

exp userid=bms/bms File=backup/logicalbackup.dmp log=backup/logicalbackup.log feedback=2000 full=y

Export: Release 10.1.0.2.0 - Production on Tue Jul 10 16:23:35 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 29516 encountered
ORA-29516: Aurora assertion failure: Assertion failure at eox.c:317
Uncaught exception Root of all Java exceptions: java.lang.NullPointerException
EXP-00000: Export terminated unsuccessfully

Reply me soon

thanks

Report message to a moderator

Re: Export problem [message #250526 is a reply to message #250522]

Tue, 10 July 2007 06:18

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Make sure your DB version and java version is compatible.

Report message to a moderator

Re: Export problem [message #250528 is a reply to message #250526]

Tue, 10 July 2007 06:25

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

hi

I have just installed the database and migrate the database.

and eveything going fine.

i watch the version it is same .

Reply soon

Thanks

Report message to a moderator

Re: Export problem [message #250599 is a reply to message #250528]

Tue, 10 July 2007 10:48

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

Possible Export Errors Related to Java Synonyms If an export operation attempts to export a synonym named DBMS_JAVA when there is no corresponding DBMS_JAVA package or when Java is either not loaded or loaded incorrectly, the export will terminate unsuccessfully. The error messages that are generated include, but are not limited to, the following: EXP-00008, ORA-00904, and ORA-29516.

If Java is enabled, make sure that both the DBMS_JAVA synonym and DBMS_JAVA package are created and valid before rerunning the export.

If Java is not enabled, remove Java-related objects before rerunning the export.

http://orafaq.com/usenet/comp.databases.oracle.misc/2005/12/12/0179.htm

Report message to a moderator