OraFAQ Forum: Server Administration » dblink Oracle9.2 -> Oracle8.1.7 -> Oracle7.3

Home » RDBMS Server » Server Administration » dblink Oracle9.2 -> Oracle8.1.7 -> Oracle7.3

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

dblink Oracle9.2 -> Oracle8.1.7 -> Oracle7.3 [message #55002]

Tue, 24 December 2002 23:44

Andrey
Messages: 21
Registered: January 1999

Junior Member

I create db-linkes and synonyms "test_perf" from Oracle9.2 through Oracle8.1.7 to Oracle7.3 table.
I run sql-command:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production

SQL> select KDCX from test_perf where rownum < 2;

KDCX
----------
145

SQL>

But following command fail:

SQL> create table test1 as select * from test_perf where rownum < 2;

ERROR at line 1:
ORA-00600: internal error code, arguments: [[qctstc2o1]], [[1]], [[0]], [[152]], [[1]],
[[30]], [[30]], [[]]

What is this ?

Report message to a moderator

Re: dblink Oracle9.2 -> Oracle8.1.7 -> Oracle7.3 [message #55012 is a reply to message #55002]

Thu, 26 December 2002 06:25

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This is a bug, where ORA-600:[[QCTSTC2O1]] is signaled 
instead of ORA-997 from INSERT..SELECT FROM a table 
over a DB link to an 8i database. The bug is fixed in 
the 8.1.7.3 patchset release.

Report message to a moderator

Previous Topic:	AT windows NT command
Next Topic:	Mutating trigger problem..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:33:30 CDT 2024