Home » RDBMS Server » Networking and Gateways » Cannot insert through database link from 10g to 8.1.7 (Oracle 10.2, Windows 2003)
Cannot insert through database link from 10g to 8.1.7 [message #302691] Tue, 26 February 2008 11:29 Go to next message
rfcdba
Messages: 1
Registered: February 2008
Location: Massachusetts
Junior Member
I cannot insert into a table from a 10g database through a database link to an Oracle 8 database. I can do the same insert into an Oracle 9 database. Below is the error I get.

ORA-02068: following severe error from ORA8DB
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-02063: preceding line from ORA10G
Any ideas??
Re: Cannot insert through database link from 10g to 8.1.7 [message #302696 is a reply to message #302691] Tue, 26 February 2008 12:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
02068, 00000, "following severe error from %s%s"
// *Cause: A severe error (disconnect, fatal Oracle error) received from
//         the indicated database link.  See following error text.
// *Action: Contact the remote system administrator.


There should also be 1 or 2 trace files which might provide additional details about the cause of this failure.

Typically ORA-00600 are Oracle bugs & require a Service Request be submitted.
Re: Cannot insert through database link from 10g to 8.1.7 [message #302700 is a reply to message #302691] Tue, 26 February 2008 12:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
10g to 8i or the opposite database links are not supported.

Regards
Michel
Re: Cannot insert through database link from 10g to 8.1.7 [message #302717 is a reply to message #302700] Tue, 26 February 2008 14:52 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that you'll have to have Oracle 9i instance in between 8.1.7 and 10g. Create database links (from 8.1.7 to 9i, and from 9i to 10g). Insert data from 8.1.7 to 9i via its database link, and have a database trigger which will transfer data further to 10g.
Previous Topic: TNSnames.ora
Next Topic: Remote connection to Oracle
Goto Forum:
  


Current Time: Fri Mar 29 05:17:15 CDT 2024