DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

Threaded View

  1. #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 04:13 PM.

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