|
최길호
[LIST]
|
2022-05-06 20:34:27, 조회 : 211 |
SYS@ORCL> insert into SCOTT.TEST values (null,null,null,null);
insert into SCOTT.TEST values (null,null,null,null)
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.TEST_PK) violated
alter table SCOTT.TEST DISABLE CONSTRAINT TEST_PK;
ORA-02431: cannot disable constraint (TEST_PK) - no such constraint
select OWNER,TABLE_NAME,CONSTRAINT_NAME from dba_constraints where TABLE_NAME = 'TEST' and OWNER='SCOTT' ;
no rows selected
SET LONG 2000000
SET PAGESIZE 0
SELECT DBMS_METADATA.GET_DDL('TABLE','TEST','SCOTT') FROM dual;
SELECT DBMS_METADATA.GET_DDL('INDEX','TEST_PK','SCOTT') FROM dual;
|
3.235.78.122
|
|
06/29 