RE: Getting ORA-01732 trying to insert into table (NOT view)

The interesting thing I've since tried is that it will work on our production database (which is Novell 8.1.5.0.4), but not on the archive (NT 8.1.5.0.0) or the test one (which was made from an export of the archive) that I'm trying to set up.

The archive was made from a backup of the former production server before it was converted from NT to Novell.

I get the same error on some other tables, too, but I can insert on some as well.

There are no specific privileges for this table or its columns as shown in dba_tab_privs or dba_col_privs.

It gives me the same error if I drop the public synonym as you would expect.

There are no triggers on this table.

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

>>> abardeen1_at_yahoo.com 05/05/01 08:30AM >>>
Ian,

You are correct. If you're connected as FARS_OWNER the public synonym will not be referenced since you own a table named MFGALIASTYPE.

I suspect the error is not being signaled by the insert itself, but by some underlying recursive sql. Is there a trigger on this table? If not, the trace file generated by the following events should help (you may need to log a tar with support for assistance in reading the trace file).

alter session set events '10046 trace name context forever, level 4';
alter session set events 1732 trace name errorstack forever, level 10';

HTH,

• Anita

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Ray
  INET: Michael.Ray_at_trw.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).