1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
|
Create table APPOWNER.APP_ALL_CONS_COLUMNS as select * from ALL_CONS_COLUMNS;
create synonym APPOWNER.ALL_CONS_COLUMNS for APPOWNER.APP_ALL_CONS_COLUMNS;
Create table APPOWNER.APP_ALL_CONSTRAINTS
(
OWNER VARCHAR2(30),
CONSTRAINT_NAME VARCHAR2(30) NOT NULL,
CONSTRAINT_TYPE VARCHAR2(1),
TABLE_NAME VARCHAR2(30) NOT NULL,
SEARCH_CONDITION LONG,
R_OWNER VARCHAR2(30),
R_CONSTRAINT_NAME VARCHAR2(30),
DELETE_RULE VARCHAR2(9),
STATUS VARCHAR2(8),
DEFERRABLE VARCHAR2(14),
DEFERRED VARCHAR2(9),
VALIDATED VARCHAR2(13),
GENERATED VARCHAR2(14),
BAD VARCHAR2(3),
RELY VARCHAR2(4),
LAST_CHANGE DATE,
INDEX_OWNER VARCHAR2(30),
INDEX_NAME VARCHAR2(30),
INVALID VARCHAR2(7),
VIEW_RELATED VARCHAR2(14)
);
declare
Cursor GetData is Select * from all_constraints;
lRec all_constraints%rowtype;
Begin
OPEN GetData;
LOOP
FETCH GetData INTO lRec;
EXIT WHEN GetData%NOTFOUND;
Insert into APPOWNER.APP_ALL_CONSTRAINTS
values
(lRec.OWNER ,
lRec.CONSTRAINT_NAME ,
lRec.CONSTRAINT_TYPE ,
lRec.TABLE_NAME ,
lRec.SEARCH_CONDITION ,
lRec.R_OWNER ,
lRec.R_CONSTRAINT_NAME,
lRec.DELETE_RULE ,
lRec.STATUS ,
lRec.DEFERRABLE ,
lRec.DEFERRED ,
lRec.VALIDATED ,
lRec.GENERATED ,
lRec.BAD ,
lRec.RELY ,
lRec.LAST_CHANGE ,
lRec.INDEX_OWNER ,
lRec.INDEX_NAME ,
lRec.INVALID ,
lRec.VIEW_RELATED);
End Loop;
Close GetData;
commit;
End;
/
create synonym APPOWNER.all_constraints for APPOWNER.APP_ALL_CONSTRAINTS; |
Partager