Home » RDBMS Server » Server Utilities » Export problem
Export problem [message #250522] Tue, 10 July 2007 06:07 Go to next message
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

Re: Export problem [message #250526 is a reply to message #250522] Tue, 10 July 2007 06:18 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Make sure your DB version and java version is compatible.
Re: Export problem [message #250528 is a reply to message #250526] Tue, 10 July 2007 06:25 Go to previous messageGo to next message
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
Re: Export problem [message #250599 is a reply to message #250528] Tue, 10 July 2007 10:48 Go to previous messageGo to next message
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
Re: Export problem [message #250955 is a reply to message #250599] Thu, 12 July 2007 00:41 Go to previous messageGo to next message
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
Member
hi

well u ask me which package would i install ?


and where is the place ?




thanks
Re: Export problem [message #251214 is a reply to message #250955] Thu, 12 July 2007 13:04 Go to previous message
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

$ORACLE_HOME/rdbms/admin/
Previous Topic: Custom function in SQL Loader
Next Topic: Warning when using sql loader
Goto Forum:
  


Current Time: Sun Dec 04 08:37:03 CST 2016

Total time taken to generate the page: 0.26660 seconds