Ora-604 And Ora-942 Running An Insert Statement
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Ora-604 And Ora-942 Running An Insert Statement

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Ora-604 And Ora-942 Running An Insert Statement

    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

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Are you using the proper synonym for that table? can you do a describe of the table you are trying to insert?
    -- Dilip

  3. #3
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114
    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
    )
    /
    Last edited by hhbrazil; 10-31-2003 at 03:13 PM.

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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?
    -- Dilip

  5. #5
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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_****.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #6
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    To Mr. Patel_dil

    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.

  7. #7
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    To Mr. OracleDoc

    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

  8. #8
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    I think I understand your problem here..........

    Your babel fish has fallen out.

  9. #9
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
    I'm stmontgo and I approve of this message

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width