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

1.以sys/oracle登录

-- 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;

-- Create table

create table ASSOCIATION$

(

OBJ# NUMBER not null,

PROPERTY NUMBER not null,

INTCOL# NUMBER,

STATSTYPE# NUMBER,

DEFAULT_SELECTIVITY NUMBER,

DEFAULT_CPU_COST NUMBER,

DEFAULT_IO_COST NUMBER,

DEFAULT_NET_COST NUMBER,

INTERFACE_VERSION# NUMBER,

SPARE2 NUMBER

)

tablespace SYSTEM

　　pctfree 10

　　pctused 40

　　initrans 1

　　maxtrans 255

　　storage

　 (

　　　　initial 64K

　　　　minextents 1

　　　　maxextents unlimited

　　);

-- Create/Recreate indexes

　　create unique index ASSOC1 on ASSOCIATION$ (OBJ#, INTCOL#) tablespace SYSTEM pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); create index ASSOC2 on ASSOCIATION$ (STATSTYPE#) tablespace SYSTEM pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited );

4.OK

巴特西

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

最新文章

热门文章