Ora-604 And Ora-942 Running An Insert Statement

[hhbrazil]

When I try make the insert bellow

INSERT INTO MPUSNTAB (SNCODE, DES, SHDES, SNIND, REC_VERSION)
VALUES (344 , 'Despacho' , 'D' , 'Y' , 1)

ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view
does not exis

And look this bellow

PNXTL02> select * from dba_tables where table_name ='


Owner Table_name Tablespace
------------ ------------------------ ---------------------
SYSADM MPUSNTAB BSCS_DATA

Way??

Database version Oracle 8.1.7.2

[patel_dil]

Are you using the proper synonym for that table? can you do a describe of the table you are trying to insert?

[hhbrazil]

Yes!

PNXTL02-> select object_name , object_type , owner from dba_objects where object_name='MPUSNTAB';

Object Type Owner
------------------------------ --------------- ------------
MPUSNTAB SYNONYM PUBLIC
MPUSNTAB TABLE SYSADM
MPUSNTAB SYNONYM BSC
MPUSNTAB SYNONYM SISTEMA_VIEWER
MPUSNTAB SYNONYM BSCUSR

The table .....

CREATE TABLE mpusntab
(sncode NUMBER NOT NULL,
rec_version NUMBER NOT NULL,
des VARCHAR2(30),
shdes VARCHAR2(5),
snind VARCHAR2(1)
,
PRIMARY KEY (sncode)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE rtx_data
STORAGE (
INITIAL 40960
NEXT 40960
PCTINCREASE 50
MINEXTENTS 1
MAXEXTENTS 505
))
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE bscs_data
STORAGE (
INITIAL 40960
NEXT 40960
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
)
/

[patel_dil]

Since this error is related to data dictionary, you may want to do a sql trace and find exactly what recursive sql is giving problem.

btw, is this happening on database which has been imported recently or did you migrate this from old version?

[OracleDoc]

I have to ask this because of past experience with individuals on this board (so don't take offense). But.... are you logged into the database as the owner of that table or does the user have privs to do DDL on this table? The only reason I ask this is because I see DBA_***** being used instead of USER_****.

[hhbrazil]

this database is a base of tests (Beta) and clone of one another database that is of production, only that without some tablespaces that they are part of the same one (production). The error is realy of catalogue, but already I am with the TAR opened in the ORACLE and the same one is delaying very to find the error.

[hhbrazil]

Let us see, 1) Debtor for the attention 2)I understend its position, 3) Yes as 4)And owner of table this giving this error if to try to register in cadastre any information in any table that has come of database "colone" gives to this error 5)Only for when I recreate the table, what technicaly is not possible therefore exists tables in this that has 250 million lines. Database of billing is one

[Horace]

I think I understand your problem here..........

Your babel fish has fallen out.

[stmontgo]

Originally posted by OracleDoc
I have to ask this because of past experience with individuals on this board (so don't take offense). But.... are you logged into the database as the owner of that table or does the user have privs to do DDL on this table? The only reason I ask this is because I see DBA_***** being used instead of USER_****.

ah hmmm.....what he said