昨日删除一数据库选定表,当删除某张表时当在那里,后来核对表结构变成如下情况
key 的显示列变为:
BIN$a6owOCHVS3G+5kF+LNP1SA==$0 Primary UNID Y N N 2010-3-6 0:05:39
check的显示列变为:
BIN$Yi/kyL/ORHOTZ/rwktF6FQ==$0 "UNID" IS NOT NULL Y N N 2010-3-6 0:05:39该表创建sql也变成如下:
-- Create table
create table APAS_MATERIAL
(
UNID VARCHAR2(32),
SERVICEUNID VARCHAR2(32),
SORTID INTEGER,
INFONAME VARCHAR2(1000),
MEMO VARCHAR2(2000),
FORMID VARCHAR2(32),
CREATETIME VARCHAR2(20),
ATTACHCODE VARCHAR2(32),
ATTACHSORT VARCHAR2(32),
IMPORTANTLEVEL VARCHAR2(1) default 1,
AFFIXTYPE NUMBER(4),
PHASE VARCHAR2(10),
NEEDTYPE NUMBER(4),
NEEDNUMBER NUMBER(4),
FILESIGN VARCHAR2(20)
)
tablespace HZAPAS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 2M
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column APAS_MATERIAL.UNID
is '资料unid编号';
comment on column APAS_MATERIAL.SERVICEUNID
is '服务项目unid编号';
comment on column APAS_MATERIAL.SORTID
is '排序号';
comment on column APAS_MATERIAL.INFONAME
is '资料名称';
comment on column APAS_MATERIAL.MEMO
is '资料说明';
comment on column APAS_MATERIAL.FORMID
is '在线资料填报表单unid';
comment on column APAS_MATERIAL.CREATETIME
is '创建时间';
comment on column APAS_MATERIAL.ATTACHCODE
is '附件编号';
comment on column APAS_MATERIAL.ATTACHSORT
is '用于设置材料分类';
comment on column APAS_MATERIAL.IMPORTANTLEVEL
is '材料等级(0为最高等级,1,2依次类推)';
comment on column APAS_MATERIAL.AFFIXTYPE
is 'ADD 2008-07-01 0表示进件,1表示出件';
comment on column APAS_MATERIAL.PHASE
is 'ADD 2008-07-01 阶段';
comment on column APAS_MATERIAL.NEEDTYPE
is 'ADD 2008-07-01 材料类型 (1纸质;2电子格式;3需要扫描)';
comment on column APAS_MATERIAL.NEEDNUMBER
is 'ADD 2008-07-01 需要数量';
comment on column APAS_MATERIAL.FILESIGN
is '增加事项相关';
-- Create/Recreate primary, unique and foreign key constraints
alter table APAS_MATERIAL
add constraint BIN$a6owOCHVS3G+5kF+LNP1SA==$0 primary key (UNID);
-- Create/Recreate check constraints
alter table APAS_MATERIAL
add constraint BIN$Yi/kyL/ORHOTZ/rwktF6FQ==$0
check ("UNID" IS NOT NULL);尝试对该表sql重新编译失败,删除操作也失败。
求解决办法。
key 的显示列变为:
BIN$a6owOCHVS3G+5kF+LNP1SA==$0 Primary UNID Y N N 2010-3-6 0:05:39
check的显示列变为:
BIN$Yi/kyL/ORHOTZ/rwktF6FQ==$0 "UNID" IS NOT NULL Y N N 2010-3-6 0:05:39该表创建sql也变成如下:
-- Create table
create table APAS_MATERIAL
(
UNID VARCHAR2(32),
SERVICEUNID VARCHAR2(32),
SORTID INTEGER,
INFONAME VARCHAR2(1000),
MEMO VARCHAR2(2000),
FORMID VARCHAR2(32),
CREATETIME VARCHAR2(20),
ATTACHCODE VARCHAR2(32),
ATTACHSORT VARCHAR2(32),
IMPORTANTLEVEL VARCHAR2(1) default 1,
AFFIXTYPE NUMBER(4),
PHASE VARCHAR2(10),
NEEDTYPE NUMBER(4),
NEEDNUMBER NUMBER(4),
FILESIGN VARCHAR2(20)
)
tablespace HZAPAS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 2M
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column APAS_MATERIAL.UNID
is '资料unid编号';
comment on column APAS_MATERIAL.SERVICEUNID
is '服务项目unid编号';
comment on column APAS_MATERIAL.SORTID
is '排序号';
comment on column APAS_MATERIAL.INFONAME
is '资料名称';
comment on column APAS_MATERIAL.MEMO
is '资料说明';
comment on column APAS_MATERIAL.FORMID
is '在线资料填报表单unid';
comment on column APAS_MATERIAL.CREATETIME
is '创建时间';
comment on column APAS_MATERIAL.ATTACHCODE
is '附件编号';
comment on column APAS_MATERIAL.ATTACHSORT
is '用于设置材料分类';
comment on column APAS_MATERIAL.IMPORTANTLEVEL
is '材料等级(0为最高等级,1,2依次类推)';
comment on column APAS_MATERIAL.AFFIXTYPE
is 'ADD 2008-07-01 0表示进件,1表示出件';
comment on column APAS_MATERIAL.PHASE
is 'ADD 2008-07-01 阶段';
comment on column APAS_MATERIAL.NEEDTYPE
is 'ADD 2008-07-01 材料类型 (1纸质;2电子格式;3需要扫描)';
comment on column APAS_MATERIAL.NEEDNUMBER
is 'ADD 2008-07-01 需要数量';
comment on column APAS_MATERIAL.FILESIGN
is '增加事项相关';
-- Create/Recreate primary, unique and foreign key constraints
alter table APAS_MATERIAL
add constraint BIN$a6owOCHVS3G+5kF+LNP1SA==$0 primary key (UNID);
-- Create/Recreate check constraints
alter table APAS_MATERIAL
add constraint BIN$Yi/kyL/ORHOTZ/rwktF6FQ==$0
check ("UNID" IS NOT NULL);尝试对该表sql重新编译失败,删除操作也失败。
求解决办法。
如果要引用这种对象,请加双引号
"BIN$Yi/kyL/ORHOTZ/rwktF6FQ==$0"
是不的有锁没有释放?
回3楼,查了下死锁的记录,sys用户下有死的记录,重启了下oracle然后可以删除了,谢谢2位