IOTs, db_links from 8.0.4 to 7.3.3.5

Has anyone come across this -

I can't contact Oracle support on it, because they've managed to expire my SAC (without stopping the bills coming, mind you), and I haven't found it on MetaLink 1.7

HP-UX 10.20
Oracle 8.0.4
Database link to Oracle 7.3.3.5

create an IOT table (

    list of columns and pk constraint
)
as

    select

        list of columns from table_at_D7335 ;

The process crashes, and about 30 seconds later the Oracle 8 instance crashes.

Attempted work-around - create a local view of the remote table.

    create view ABC as select list of columns from table_at_D7335.

Then try to create the table by selecting from the local view. Oracle 8 stays up, the process stays up, but reports

    ORA-02068 (severe error from remote database)     ORA-00600 with parameter [],[],[],[],[],[],[],[]

On the other hand, the 7.3.3.5 database is showing a trace file that says it parsed, executed and fetched - and got all the required rows - and then closed correctly !!

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk Received on Mon Jun 28 1999 - 12:18:53 CDT