无法顺利删除问题处理一则-ORA-00604和ORA-00942错误

1.以sys/oracle登录

2.

-- Create table
create table ARGUMENT$
(
  OBJ#          NUMBER not null,
  PROCEDURE$    VARCHAR2(30),
  OVERLOAD#     NUMBER not null,
  PROCEDURE#    NUMBER,
  POSITION#     NUMBER not null,
  SEQUENCE#     NUMBER not null,
  LEVEL#        NUMBER not null,
  ARGUMENT      VARCHAR2(30),
  TYPE#         NUMBER not null,
  CHARSETID     NUMBER,
  CHARSETFORM   NUMBER,
  DEFAULT#      NUMBER,
  IN_OUT        NUMBER,
  PROPERTIES    NUMBER,
  LENGTH        NUMBER,
  PRECISION#    NUMBER,
  SCALE         NUMBER,
  RADIX         NUMBER,
  DEFLENGTH     NUMBER,
  DEFAULT$      LONG,
  TYPE_OWNER    VARCHAR2(30),
  TYPE_NAME     VARCHAR2(30),
  TYPE_SUBNAME  VARCHAR2(30),
  TYPE_LINKNAME VARCHAR2(128),
  PLS_TYPE      VARCHAR2(30)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes
create unique index I_ARGUMENT1 on ARGUMENT$ (OBJ#, PROCEDURE$, OVERLOAD#, SEQUENCE#)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    minextents 1
    maxextents unlimited
  );
create index I_ARGUMENT2 on ARGUMENT$ (OBJ#, PROCEDURE#, SEQUENCE#)
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    minextents 1
    maxextents unlimited
  );
-- Grant/Revoke object privileges
grant select on ARGUMENT$ to CTXSYS with grant option;

3.

无法顺利删除问题处理一则-ORA-00604和ORA-00942错误,布布扣,bubuko.com

无法顺利删除问题处理一则-ORA-00604和ORA-00942错误

原文：http://www.cnblogs.com/dengpeng1004/p/3586713.html