| 간단소개 |
--------------------------------------------------------------------------------
-- 트리거 활성화 / 비활성화
--------------------------------------------------------------------------------
-- 비활성화
ALTER TRIGGER TRGGR_ORD_DRDL_APLY_LOG DISABLE;
-- 활성화
ALTER TABLE TRGGR_ORD_DRDL_APLY_LOG ENABLE;
-- 전체 비활성화
alter table ORD_DRDL_APLY disable all triggers;
-- 전체 활성화
alter table ORD_DRDL_APLY ENABLE all triggers;
--------------------------------------------------------------------------------
-- 테이블 조회 view
--------------------------------------------------------------------------------
CREATE OR REPLACE FORCE VIEW SHERP.VI_TABLES
(
TABLE_ID -- 테이블ID
, TABLE_NM -- 테이블명
, COLUMN_ID -- 컬럼ID
, COLUMN_NM -- 컬럼명
, COL_ID -- 컬럼순서
, PK -- PK 순서
, TYPE -- DATA TYPE
, LENGTH -- DATA길이
, NULL_YN -- NULL 여부
, "DEFAULT" -- 기본값
)
AS
--------------------------------------------------------------------------------
-- TABLE + COLUMN 정보
--------------------------------------------------------------------------------
SELECT
A.TABLE_NAME AS "TABLE_ID" -- 테이블ID
, B.COMMENTS AS "TABLE_NM" -- 테이블명
, D.COLUMN_NAME AS "COLUMN_ID" -- 컬럼ID
, D.COMMENTS AS "COLUMN_NM" -- 컬럼명
, C.COLUMN_ID AS "COL_ID" -- 컬럼순서
, E.POSITION AS "PK" -- PK 순서
, C.DATA_TYPE AS "TYPE" -- DATA TYPE
, (CASE WHEN C.DATA_TYPE IN ('CLOB', 'BLOB') THEN ''
WHEN NVL(C.DATA_PRECISION, 0) = 0 THEN TO_CHAR(C.DATA_LENGTH)
WHEN C.DATA_SCALE = 0 THEN TO_CHAR(C.DATA_PRECISION)
ELSE C.DATA_PRECISION || ',' || C.DATA_SCALE
END) AS "LENGTH" -- DATA길이
, C.NULLABLE AS "NULL_YN" -- NULL 여부
, C.DATA_DEFAULT AS "DEFAULT" -- 기본값
FROM ALL_TABLES A -- TABLE 정보
, ALL_TAB_COMMENTS B -- 테이블 주석정보
, ALL_TAB_COLUMNS C -- TABLE COLUMN 정보
, ALL_COL_COMMENTS D -- TABLE COLUMN 주석 정보
, (SELECT A.*
FROM USER_CONS_COLUMNS A
, USER_CONSTRAINTS B
WHERE A.OWNER = B.OWNER
AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND B.CONSTRAINT_TYPE = 'P' -- PRIMARY KEY
AND A.POSITION IS NOT NULL
) E -- 제약 조건 COLUMN_ 정보
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.OWNER = C.OWNER
AND A.TABLE_NAME = C.TABLE_NAME
AND C.OWNER = D.OWNER
AND C.TABLE_NAME = D.TABLE_NAME
AND C.COLUMN_NAME = D.COLUMN_NAME
AND C.TABLE_NAME = E.TABLE_NAME (+)
AND C.COLUMN_NAME = E.COLUMN_NAME (+)
AND A.OWNER = 'SHERP' -- || '%'
-- AND A.TABLE_NAME LIKE UPPER('') || '%' -- TABLE_ ID
-- AND NVL(B.COMMENTS,'X') LIKE UPPER('') || '%' -- TABLE_NM
-- AND D.COLUMN_NAME LIKE UPPER('') || '%' -- COLUMN_ ID
-- AND NVL(D.COMMENTS,'X') LIKE UPPER('') || '%' -- COLUMN_NM
ORDER BY A.TABLE_NAME
, C.COLUMN_ID
, C.COLUMN_ID ASC
;
--------------------------------------------------------------------------------
-- 시스템 뷰 기본 구성
--------------------------------------------------------------------------------
DBA_ : 해당 데이터 베이스에 존재하는 모든 내용조회 가능
ALL_ : 해당 유저에게 권한이 존재하는 모든 내용 조회 가능
USER_ : 해당 유저가 소유자(Owner)로 되어 있는 모든 내용 조회 가능
* 오라클 뷰 목록
-- 권한 별로 DBA_,ALL_,USER_를 선택해서 아래 리스트 앞에 붙여서 사용
EX) ALL_COL_COMMENTS
- CLUSTERS(CLU) -- 클러스터 정보
- COL_COMMENTS -- 컬럼 주석 정보
- COL_PRIVS -- 컬럼 권한 정보
- COL_PRIVS_MADE -- 내가 부여한 컬럼 권한
- COL_PRIVS_RECD -- 내가 부여받은 컬럼 권한
- CONS_COLUMNS -- 제약 조건을 가진 컬럼들에 대한 정보
- CONSTRAINTS -- 각종 제약 조건
- DB_LINKS -- 디비 링크 정보
- IND_COLUMNS -- 인덱스 컬럼 정보
- INDEXES(IND) -- 인덱스 정보
- OBJECTS -- 모든 USER 오브젝트들
- PROCEDURES -- 프로시저, 함수, 패키지 정보
- SEQUENCES(SEQ) -- 시퀀스 정보
- SOURCE -- 트리거, 함수, 프로시저, 패키지 소스
- SYNONYMS(SYN) -- 시노님 정보
- SYS_PRIVS -- 시스템 권한 정보
- TAB_COLUMNS(COLS) -- 테이블에 있는 컬럼들의 정보
- TAB_COMMENTS -- 테이블 주석 정보
- TAB_PRIVS -- 테이블 권한 정보
- TAB_PRIVS_MADE -- 내가 부여한 테이블 권한
- TAB_PRIVS_RECD -- 내가 부여받은 테이블 권한
- TABLES -- 테이블 정보
- TABLESPACES -- 테이블 스페이스 정보
- TRIGGERS -- 트리거 정보
- USERS -- 사용자 정보
- VIEWS -- 뷰 정보
--------------------------------------------------------------------------------
-- 테이블 및 컬럼 조회 view 생성
--------------------------------------------------------------------------------
CREATE OR REPLACE FORCE VIEW SHERP.VI_TABLES
(
TABLE_ID -- 테이블ID
, TABLE_NM -- 테이블명
, COLUMN_ID -- 컬럼ID
, COLUMN_NM -- 컬럼명
, COL_ID -- 컬럼순서
, PK -- PK 순서
, TYPE -- DATA TYPE
, LENGTH -- DATA길이
, NULL_YN -- NULL 여부
, "DEFAULT" -- 기본값
)
AS
--------------------------------------------------------------------------------
-- TABLE + COLUMN 정보
--------------------------------------------------------------------------------
SELECT
A.TABLE_NAME AS "TABLE_ID" -- 테이블ID
, B.COMMENTS AS "TABLE_NM" -- 테이블명
, D.COLUMN_NAME AS "COLUMN_ID" -- 컬럼ID
, D.COMMENTS AS "COLUMN_NM" -- 컬럼명
, C.COLUMN_ID AS "COL_ID" -- 컬럼순서
, E.POSITION AS "PK" -- PK 순서
, C.DATA_TYPE AS "TYPE" -- DATA TYPE
, (CASE WHEN C.DATA_TYPE IN ('CLOB', 'BLOB') THEN ''
WHEN NVL(C.DATA_PRECISION, 0) = 0 THEN TO_CHAR(C.DATA_LENGTH)
WHEN C.DATA_SCALE = 0 THEN TO_CHAR(C.DATA_PRECISION)
ELSE C.DATA_PRECISION || ',' || C.DATA_SCALE
END) AS "LENGTH" -- DATA길이
, C.NULLABLE AS "NULL_YN" -- NULL 여부
, C.DATA_DEFAULT AS "DEFAULT" -- 기본값
FROM ALL_TABLES A -- TABLE 정보
, ALL_TAB_COMMENTS B -- 테이블 주석정보
, ALL_TAB_COLUMNS C -- TABLE COLUMN 정보
, ALL_COL_COMMENTS D -- TABLE COLUMN 주석 정보
, (SELECT A.*
FROM USER_CONS_COLUMNS A
, USER_CONSTRAINTS B
WHERE A.OWNER = B.OWNER
AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND B.CONSTRAINT_TYPE = 'P' -- PRIMARY KEY
AND A.POSITION IS NOT NULL
) E -- 제약 조건 COLUMN_ 정보
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.OWNER = C.OWNER
AND A.TABLE_NAME = C.TABLE_NAME
AND C.OWNER = D.OWNER
AND C.TABLE_NAME = D.TABLE_NAME
AND C.COLUMN_NAME = D.COLUMN_NAME
AND C.TABLE_NAME = E.TABLE_NAME (+)
AND C.COLUMN_NAME = E.COLUMN_NAME (+)
AND A.OWNER = 'SHERP' -- || '%'
-- AND A.TABLE_NAME LIKE UPPER('') || '%' -- TABLE_ ID
-- AND NVL(B.COMMENTS,'X') LIKE UPPER('') || '%' -- TABLE_NM
-- AND D.COLUMN_NAME LIKE UPPER('') || '%' -- COLUMN_ ID
-- AND NVL(D.COMMENTS,'X') LIKE UPPER('') || '%' -- COLUMN_NM
ORDER BY A.TABLE_NAME
, C.COLUMN_ID
, C.COLUMN_ID ASC
;
--------------------------------------------------------------------------------
-- 전체 테이블 건수
--------------------------------------------------------------------------------
SELECT TABLE_NAME
, NUM_ROWS AS "통계정보 건수"
, TO_NUMBER(DBMS_XMLGEN.GETXMLTYPE('SELECT COUNT(*) C FROM ' || TABLE_NAME).EXTRACT('//TEXT()')) AS "실제측정 건수"
FROM USER_TABLES
;
--------------------------------------------------------------------------------
-- 물자열 합치기 : 행을 열로
-- GROUP BY 이용
--------------------------------------------------------------------------------
WITH T(TYPE, NAME, CODE) AS
(
SELECT '과일', '사과', '0' FROM DUAL
UNION ALL SELECT '과일', '레몬', '1' FROM DUAL
UNION ALL SELECT '과일', '포도', '2' FROM DUAL
UNION ALL SELECT '과일', '참외', '3' FROM DUAL
UNION ALL SELECT '채소', '오이', '0' FROM DUAL
UNION ALL SELECT '채소', '당근', '1' FROM DUAL
UNION ALL SELECT '채소', '호박', '2' FROM DUAL
)
SELECT TYPE
, SUBSTR(XMLAGG(XMLELEMENT(X, ',', NAME) ORDER BY CODE).EXTRACT('//TEXT()'), 2) ORACLE_9I
, TO_CHAR(WM_CONCAT(NAME)) AS ORACLE_10G
, LISTAGG(NAME, ',') WITHIN GROUP(ORDER BY CODE) AS ORACLE_11G
FROM T
GROUP BY TYPE
ORDER BY TYPE
;
-- 결과
1 과일 사과,레몬,포도,참외 사과,참외,포도,레몬 사과,레몬,포도,참외
2 채소 오이,당근,호박 오이,호박,당근 오이,당근,호박
--------------------------------------------------------------------------------
-- 행 복제, 행을 열로
--------------------------------------------------------------------------------
-- 1. 행복제 기본 유형과 조인
-- 쓸데 없이 많은 수(99) 만큼 복제하여 조인하는 비효율 발생
WITH T AS
(
SELECT 1 PK, 2 CNT FROM DUAL
UNION ALL SELECT 2, 4 FROM DUAL
UNION ALL SELECT 3, 6 FROM DUAL
)
SELECT PK, CNT, LV
FROM T
, (SELECT LEVEL LV FROM DUAL CONNECT BY LEVEL <= 99)
WHERE LV <= CNT
ORDER BY PK, LV
;
-- DBMS_RANDOM.VALUE 조건 삽입.
-- 11.2.0.1.0 버전에서 사용 가능
SELECT PK, CNT, LEVEL LV
FROM T
CONNECT BY LEVEL <= CNT
AND PRIOR PK = PK
AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL
;
-- 11G RECURSIVE SQL
WITH T AS
(
SELECT 1 PK, 2 CNT FROM DUAL
UNION ALL SELECT 2, 4 FROM DUAL
UNION ALL SELECT 3, 6 FROM DUAL
)
, T1(PK, CNT, LV) AS
(
SELECT PK, CNT
, 1 LV
FROM T
UNION ALL
SELECT PK, CNT
, LV + 1 LV
FROM T1
WHERE LV + 1 <= CNT
)
SELECT *
FROM T1
ORDER BY PK, LV
;
/***************************************************************************************************
* 콤마를 ROW로 변경 > 1만건 빠름
* 샘플
**************************************************************************************************/
WITH T(ALCD, CAPA, INJI, RESN) AS
( SELECT 'RR01', '3300,3800', 'GDI', 'KOR' FROM DUAL
UNION ALL SELECT 'RR02', '2000,2400', 'MPI,GDI', 'KOR,EUR' FROM DUAL
UNION ALL SELECT 'RR03', '1000', '', 'KOR' FROM DUAL
)
SELECT ALCD
,DECODE(CAPA,'@','',CAPA) CAPA
,DECODE(INJI,'@','',INJI) INJI
,DECODE(RESN,'@','',RESN) RESN
FROM
(SELECT T.ALCD , A.CAPA , B.INJI , C.RESN
FROM T ,
, (SELECT ALCD ,REGEXP_SUBSTR(NVL(CAPA,'@'), '[^,]+', 1, lv ) CAPA
FROM T , (SELECT LEVEL lv FROM DUAL CONNECT BY LEVEL <= 100 )
) A
, (SELECT ALCD ,REGEXP_SUBSTR(NVL(INJI,'@'), '[^,]+', 1, lv ) INJI
FROM T , (SELECT LEVEL lv FROM DUAL CONNECT BY LEVEL <= 100 )
) B
, (SELECT ALCD ,REGEXP_SUBSTR(NVL(RESN,'@'), '[^,]+', 1, lv ) RESN
FROM T , (SELECT LEVEL lv FROM DUAL CONNECT BY LEVEL <= 100 )
) C
WHERE T.ALCD = A.ALCD(+)
AND T.ALCD = B.ALCD(+)
AND T.ALCD = C.ALCD(+)
)
WHERE CAPA IS NOT NULL
AND INJI IS NOT NULL
AND RESN IS NOT NULL
;
--------------------------------------------------------------------------------
-- MODEL을 이용한 SUM(합계) 영역 추가
--------------------------------------------------------------------------------
SELECT COL_TERM
, COL_SAL
FROM (SELECT 1 NUM, '200701' TERM, 1000000 SALARY FROM DUAL UNION ALL
SELECT 2 NUM, '200702' TERM, 2000000 SALARY FROM DUAL UNION ALL
SELECT 3 NUM, '200703' TERM, 1500000 SALARY FROM DUAL UNION ALL
SELECT 4 NUM, '200704' TERM, 1900000 SALARY FROM DUAL UNION ALL
SELECT 5 NUM, '200705' TERM, 2300000 SALARY FROM DUAL UNION ALL
SELECT 6 NUM, '200706' TERM, 3000000 SALARY FROM DUAL )
MODEL
DIMENSION BY (TERM AS COL_TERM)
MEASURES ( SALARY AS COL_SAL )
RULES (
COL_SAL['분1'] = COL_SAL['200701'] + COL_SAL['200702'] + COL_SAL['200703']
, COL_SAL['분기'] = COL_SAL['200704'] + COL_SAL['200705'] + COL_SAL['200706']
, COL_SAL['평균' ] = AVG(COL_SAL) [ COL_TERM BETWEEN '200701' AND '200706' ]
, COL_SAL['합계' ] = SUM(COL_SAL) [ COL_TERM BETWEEN '200701' AND '200706' ]
)
ORDER BY 1
;
-- 결과
1 200701 1000000
2 200702 2000000
3 200703 1500000
4 200704 1900000
5 200705 2300000
6 200706 3000000
7 분1 4500000
8 분기 7200000
9 평균 1950000
10 합계 11700000
;
--------------------------------------------------------------------------------
-- 읍,면,동 치환
--------------------------------------------------------------------------------
WITH T
AS(
SELECT '서울시 용산구 논현동 114번지' AS TEST FROM DUAL UNION ALL
SELECT '부천시 소사구 심곡본동 527' AS TEST FROM DUAL UNION ALL
SELECT '강원도 횡성군 청일면 신대리' AS TEST FROM DUAL UNION ALL
SELECT '강원도 횡성군 청일면 소포동길 26' AS TEST FROM DUAL UNION ALL
SELECT '강원도 횡성군 차동면 소포동길 26' AS TEST FROM DUAL UNION ALL
SELECT '강원도 진도군 진도읍 소포리' AS TEST FROM DUAL
)
SELECT
REGEXP_REPLACE(TEST, '[^ ]+([동리가로])', '**\1') AS JUSO
, REGEXP_REPLACE(TEST, '[^ ]+([동리가로])', '**\2') AS JUSO
, REGEXP_REPLACE(TEST, '[^ ]+([동리가로])', '**\1') AS JUSO
, REGEXP_REPLACE(TEST, '[^ ]+([읍면동가로])', '**\1') AS JUSO
FROM T
;
-- 결과
1 서울시 용산구 **동 114번지 서울시 용산구 ** 114번지 서울시 용산구 **동 114번지 서울시 용산구 **동 114번지
2 부천시 소사구 **동 527 부천시 소사구 ** 527 부천시 소사구 **동 527 부천시 소사구 **동 527
3 강원도 횡성군 청일면 **리 강원도 횡성군 청일면 ** 강원도 횡성군 청일면 **리 강원도 횡성군 **면 신대리
4 강원도 횡성군 청일면 **동길 26 강원도 횡성군 청일면 **길 26 강원도 횡성군 청일면 **동길 26 강원도 횡성군 **면 **동길 26
5 강원도 횡성군 **동면 **동길 26 강원도 횡성군 **면 **길 26 강원도 횡성군 **동면 **동길 26 강원도 횡성군 **면 **동길 26
6 강원도 진도군 진도읍 **리 강원도 진도군 진도읍 ** 강원도 진도군 진도읍 **리 강원도 진도군 **읍 소포리
;
--------------------------------------------------------------------------------
-- 인덱스 생성시 사전에 EXPLAIN 정보 확인
--------------------------------------------------------------------------------
EXPLAIN PLAN FOR
CREATE INDEX IDX_TB_BA_RGLR_99 ON TB_BA_RGLR (YEAR, EMP_NO, AGE) ;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY) ;
--------------------------------------------------------------------------------
-- 문자타입 컬럼중 검색어(특정문자열)가 저장되어 있는 테이블, 컬럼 찾기
--------------------------------------------------------------------------------
SELECT TNAME
, CNAME
FROM COL
WHERE COLTYPE LIKE '%CHAR%' -- 검색할 문자열 TYPE
AND TNAME NOT LIKE 'BIN$%' -- DROP TABLE 휴지통 제외
AND TO_NUMBER(DBMS_XMLGEN.GETXMLTYPE('SELECT 1 FROM '||TNAME||' WHERE '||CNAME||' LIKE ''%검색어%'' AND ROWNUM = 1').EXTRACT('//TEXT()')) = 1
;
SELECT * FROM USER_INDEXES ;
SELECT * FROM ALL_TAB_COMMENTS;
-------------------------------------------------------------------------------
-- 테이블 조회
-------------------------------------------------------------------------------
SELECT
A.OWNER
, A.TABLE_NAME AS "테이블ID"
, B.COMMENTS AS "테이블명"
FROM ALL_TABLES A
, ALL_TAB_COMMENTS B
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.OWNER LIKE 'SHE%'
AND A.TABLE_NAME LIKE UPPER('%') || '%' -- 테이블 ID
AND NVL(B.COMMENTS,'X') LIKE UPPER('%%') -- 테이블명
ORDER BY
A.TABLE_NAME ASC
;
-------------------------------------------------------------------------------
-- 컬럼 조회
-------------------------------------------------------------------------------
SELECT
D.COMMENTS AS "컬럼명"
, D.COLUMN_NAME AS "컬럼ID"
, C.DATA_TYPE AS "유형"
, DECODE(C.DATA_PRECISION, NULL, TO_CHAR(C.DATA_LENGTH)
, C.DATA_PRECISION||','||C.DATA_SCALE
) AS "길이"
, C.NULLABLE AS "NULL여부"
FROM ALL_TAB_COLUMNS C
, ALL_COL_COMMENTS D
WHERE C.OWNER = D.OWNER
AND C.TABLE_NAME = D.TABLE_NAME
AND C.COLUMN_NAME = D.COLUMN_NAME
AND D.COLUMN_NAME LIKE UPPER('') || '%' -- 컬럼 ID
AND NVL(D.COMMENTS,'X') LIKE UPPER('%소속%') -- 컬럼명
ORDER BY
C.COLUMN_ID ASC
;
-------------------------------------------------------------------------------
-- 테이블+컬럼 조회
-------------------------------------------------------------------------------
SELECT
A.OWNER
, A.TABLE_NAME AS "테이블ID"
, B.COMMENTS AS "테이블명"
, D.COLUMN_NAME AS "컬럼ID"
, D.COMMENTS AS "컬럼명"
, C.COLUMN_ID AS "ColID"
, C.DATA_TYPE AS "유형"
, DECODE(C.DATA_PRECISION, NULL, TO_CHAR(C.DATA_LENGTH)
, C.DATA_PRECISION||','||C.DATA_SCALE
) AS "길이"
, C.NULLABLE AS "NULL여부"
, C.DATA_DEFAULT AS "Default"
FROM ALL_TABLES A
, ALL_TAB_COMMENTS B
, ALL_TAB_COLUMNS C
, ALL_COL_COMMENTS D
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.OWNER = C.OWNER
AND A.TABLE_NAME = C.TABLE_NAME
AND C.OWNER = D.OWNER
AND C.TABLE_NAME = D.TABLE_NAME
AND C.COLUMN_NAME = D.COLUMN_NAME
AND A.OWNER LIKE 'SHE%'
AND A.TABLE_NAME LIKE UPPER('TB_COM') || '%' -- 테이블 ID
AND NVL(B.COMMENTS,'X') LIKE UPPER('%%') -- 테이블명
AND D.COLUMN_NAME LIKE UPPER('%MAIL') || '%' -- 컬럼 ID
AND NVL(D.COMMENTS,'X') LIKE UPPER('%%') -- 컬럼명
ORDER BY A.TABLE_NAME
, C.COLUMN_ID
, C.COLUMN_ID ASC
;
-------------------------------------------------------------------------------
-- 테이블 + 컬럼 정보 엑셀로 받기
-------------------------------------------------------------------------------
SELECT
A.OWNER
, A.TABLE_NAME AS "테이블ID"
, B.COMMENTS AS "테이블명"
, D.COLUMN_NAME AS "컬럼ID"
, D.COMMENTS AS "컬럼명"
, C.COLUMN_ID AS "ColID"
, C.DATA_TYPE AS "유형"
, DECODE(C.DATA_PRECISION, NULL, TO_CHAR(C.DATA_LENGTH)
, C.DATA_PRECISION||','||C.DATA_SCALE
) AS "길이"
, C.NULLABLE AS "NULL여부"
, C.DATA_DEFAULT AS "Default"
, E.POSITION AS "Position"
FROM ALL_TABLES A -- 테이블 정보
, ALL_TAB_COMMENTS B -- 테이즐 주석정보
, ALL_TAB_COLUMNS C -- 테이블 컬럼 정보
, ALL_COL_COMMENTS D -- 테이블 컬럼 주석 정보
, USER_CONS_COLUMNS E -- 제약 조건 컬럼 정보
WHERE A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.OWNER = C.OWNER
AND A.TABLE_NAME = C.TABLE_NAME
AND C.OWNER = D.OWNER
AND C.TABLE_NAME = D.TABLE_NAME
AND C.COLUMN_NAME = D.COLUMN_NAME
AND C.TABLE_NAME = E.TABLE_NAME (+)
AND C.COLUMN_NAME = E.COLUMN_NAME (+)
AND A.OWNER LIKE 'SHE' -- || '%'
AND A.TABLE_NAME LIKE UPPER('') || '%' -- 테이블 ID
AND NVL(B.COMMENTS,'X') LIKE UPPER('%%') -- 테이블명
AND D.COLUMN_NAME LIKE UPPER('') || '%' -- 컬럼 ID
AND NVL(D.COMMENTS,'X') LIKE UPPER('%') -- 컬럼명
ORDER BY A.TABLE_NAME
, C.COLUMN_ID
, C.COLUMN_ID ASC
;
SELECT * FROM USER_CONSTRAINTS;
SELECT * FROM USER_CONS_COLUMNS ;
SELECT * FROM USER_TAB_COLUMNS
;
SELECT * FROM USER_INDEXES
;
SELECT * FROM USER_IND_COLUMNS
;
-------------------------------------------------------------------------------
-- 인덱스 조회
-- BLEVEL(인덱스깊이) : 4이상이면 REBUILD 고려 -
-- LEAF_BLOCKS(리프블록수) : 4이상이면 REBUILD 고려 -
--
-------------------------------------------------------------------------------
SELECT
INDEX_NAME AS "인덱스명"
, INDEX_TYPE AS "인덱스타입"
, TABLE_OWNER AS "오너"
, TABLE_NAME AS "테이블명"
, TABLE_TYPE AS "테이블타입"
, UNIQUENESS AS "UNIUE여부"
, BLEVEL AS "인덱스깊이"
, LEAF_BLOCKS AS "리프블록수"
, TABLESPACE_NAME AS "테이블스페이스"
, INI_TRANS AS "동시트랜잭션수" -- 동시에 엑세스 가능한 트랜잭션의 초기 개수
, MAX_TRANS AS "MAX트랜잭션수" -- 동시엑세스 가능한 MAX 트랜잭션 수
FROM USER_INDEXES
WHERE TABLE_OWNER = 'SHE'
AND INDEX_TYPE = 'NORMAL'
AND INDEX_NAME LIKE '%%'
ORDER BY BLEVEL DESC, LEAF_BLOCKS DESC
;
-- 인덱스 재생성
ALTER INDEX PK_TB_BZ_CODEDTL REBUILD;
-- 인덱스 통계정보 재생성
ANALYZE INDEX TB_HC_CHEMMST_BAK_IX ESTIMATE STATISTICS;
-- 테이블 통계정보 재성성
ANALYZE TABLE TB_BA_RGLR COMPUTE STATISTICS;
--EXECUTE IMMEDIATE 'ANALYZE TABLE TB_BA_RGLR COMPUTE STATISTICS';
-------------------------------------------------------------------------------
-- 모든 OBJECT 찾기
-------------------------------------------------------------------------------
SELECT *
FROM ALL_OBJECTS
WHERE UPPER(OBJECT_NAME) LIKE UPPER('') || '%'
-- AND OBJECT_TYPE LIKE '' || '%'
AND OBJECT_TYPE IN ('PROCEDURE', 'VIEW', 'FUNCTION', 'TRIGGER', 'SEQUENCE')
AND OWNER = 'SHE'
ORDER BY OBJECT_TYPE
;
-------------------------------------------------------------------------------
-- 모든 OBJECT 찾기
-------------------------------------------------------------------------------
SELECT OWNER AS "OWNER"
, OBJECT_NAME AS "OBJECT_ID"
, OBJECT_TYPE AS "OBJECT_구분"
FROM ALL_OBJECTS
WHERE UPPER(OBJECT_NAME) LIKE UPPER('') || '%'
-- AND OBJECT_TYPE LIKE '' || '%'
AND OBJECT_TYPE IN ('PROCEDURE', 'VIEW', 'FUNCTION', 'TRIGGER', 'SEQUENCE')
AND OWNER = 'SHE'
ORDER BY OBJECT_TYPE, OBJECT_ID
;
-------------------------------------------------------------------------------
-- 인덱스 조회
-- BLEVEL(인덱스깊이) : 4이상이면 REBUILD 고려 -
-- LEAF_BLOCKS(리프블록수) : 4이상이면 REBUILD 고려 -
--
-------------------------------------------------------------------------------
SELECT
INDEX_NAME AS "인덱스명"
, INDEX_TYPE AS "인덱스타입"
, TABLE_OWNER AS "오너"
, TABLE_NAME AS "테이블명"
, TABLE_TYPE AS "테이블타입"
, UNIQUENESS AS "UNIUE여부"
, BLEVEL AS "인덱스깊이"
, LEAF_BLOCKS AS "리프블록수"
, TABLESPACE_NAME AS "테이블스페이스"
, INI_TRANS AS "동시트랜잭션수" -- 동시에 엑세스 가능한 트랜잭션의 초기 개수
, MAX_TRANS AS "MAX트랜잭션수" -- 동시엑세스 가능한 MAX 트랜잭션 수
FROM USER_INDEXES
WHERE TABLE_OWNER = 'SHE'
AND INDEX_TYPE = 'NORMAL'
AND INDEX_NAME LIKE '%%'
ORDER BY BLEVEL DESC, LEAF_BLOCKS DESC
;
-- 인덱스 재생성
ALTER INDEX PK_TB_BZ_CODEDTL REBUILD;
-- 인덱스 통계정보 재생성
ANALYZE INDEX TB_HC_CHEMMST_BAK_IX ESTIMATE STATISTICS;
-- 테이블 통계정보 재성성
ANALYZE TABLE TB_BA_RGLR COMPUTE STATISTICS;
--EXECUTE IMMEDIATE 'ANALYZE TABLE TB_BA_RGLR COMPUTE STATISTICS';
--------------------------------------------------
-- DBA OBJECT 리스트
--------------------------------------------------
SYS USER_ADDM_FDG_BREAKDOWN
SYS USER_ADDM_FINDINGS
SYS USER_ADDM_INSTANCES
SYS USER_ADDM_TASKS
SYS USER_ADDM_TASK_DIRECTIVES
SYS USER_ADVISOR_ACTIONS
SYS USER_ADVISOR_EXECUTIONS
SYS USER_ADVISOR_EXEC_PARAMETERS
SYS USER_ADVISOR_FDG_BREAKDOWN
SYS USER_ADVISOR_FINDINGS
SYS USER_ADVISOR_JOURNAL
SYS USER_ADVISOR_LOG
SYS USER_ADVISOR_OBJECTS
SYS USER_ADVISOR_PARAMETERS
SYS USER_ADVISOR_RATIONALE
SYS USER_ADVISOR_RECOMMENDATIONS
SYS USER_ADVISOR_SQLA_COLVOL
SYS USER_ADVISOR_SQLA_REC_SUM
SYS USER_ADVISOR_SQLA_TABLES
SYS USER_ADVISOR_SQLA_TABVOL
SYS USER_ADVISOR_SQLA_WK_MAP
SYS USER_ADVISOR_SQLA_WK_STMTS
SYS USER_ADVISOR_SQLA_WK_SUM
SYS USER_ADVISOR_SQLPLANS
SYS USER_ADVISOR_SQLSTATS
SYS USER_ADVISOR_SQLW_COLVOL
SYS USER_ADVISOR_SQLW_JOURNAL
SYS USER_ADVISOR_SQLW_PARAMETERS
SYS USER_ADVISOR_SQLW_STMTS
SYS USER_ADVISOR_SQLW_SUM
SYS USER_ADVISOR_SQLW_TABLES
SYS USER_ADVISOR_SQLW_TABVOL
SYS USER_ADVISOR_SQLW_TEMPLATES
SYS USER_ADVISOR_TASKS
SYS USER_ADVISOR_TEMPLATES
SYS USER_ALL_TABLES
SYS USER_APPLICATION_ROLES
SYS USER_APPLY_ERROR
SYS USER_AQ_AGENT_PRIVS
SYS USER_ARGUMENTS
SYS USER_ASSEMBLIES
SYS USER_ASSOCIATIONS
SYS USER_ATTRIBUTE_TRANSFORMATIONS
SYS USER_AUDIT_OBJECT
SYS USER_AUDIT_SESSION
SYS USER_AUDIT_STATEMENT
SYS USER_AUDIT_TRAIL
SYS USER_AWS
SYS USER_AW_PS
SYS USER_BASE_TABLE_MVIEWS
SYS USER_CATALOG
SYS USER_CHANGE_NOTIFICATION_REGS
SYS USER_CLUSTERS
SYS USER_CLUSTER_HASH_EXPRESSIONS
SYS USER_CLU_COLUMNS
SYS USER_COLL_TYPES
SYS USER_COL_COMMENTS
SYS USER_COL_PENDING_STATS
SYS USER_COL_PRIVS
SYS USER_COL_PRIVS_MADE
SYS USER_COL_PRIVS_RECD
SYS USER_COMPARISON
SYS USER_COMPARISON_COLUMNS
SYS USER_COMPARISON_ROW_DIF
SYS USER_COMPARISON_SCAN
SYS USER_COMPARISON_SCAN_SUMMARY
SYS USER_COMPARISON_SCAN_VALUES
SYS USER_CONSTRAINTS
SYS USER_CONS_COLUMNS
SYS USER_CONS_OBJ_COLUMNS
SYS USER_CQ_NOTIFICATION_QUERIES
SYS USER_SYNONYMS
SYS USER_SYS_PRIVS
SYS USER_TABLES
SYS USER_TABLESPACES
SYS USER_TAB_COLS
SYS USER_TAB_COLUMNS
SYS USER_TAB_COL_STATISTICS
SYS USER_TAB_COMMENTS
SYS USER_TAB_HISTGRM_PENDING_STATS
SYS USER_TAB_HISTOGRAMS
SYS USER_TAB_MODIFICATIONS
SYS USER_TAB_PARTITIONS
SYS USER_TAB_PENDING_STATS
SYS USER_TAB_PRIVS
SYS USER_TAB_PRIVS_MADE
SYS USER_TAB_PRIVS_RECD
SYS USER_TAB_STATISTICS
SYS USER_TAB_STATS_HISTORY
SYS USER_TAB_STAT_PREFS
SYS USER_TAB_SUBPARTITIONS
SYS USER_TRANSFORMATIONS
SYS USER_TRIGGERS
SYS USER_TRIGGER_COLS
SYS USER_TRIGGER_ORDERING
SYS USER_TSTZ_TABLES
SYS USER_TSTZ_TAB_COLS
SYS USER_TS_QUOTAS
SYS USER_TUNE_MVIEW
SYS USER_TYPES
SYS USER_TYPE_ATTRS
SYS USER_TYPE_METHODS
SYS USER_TYPE_VERSIONS
SYS USER_UNUSED_COL_TABS
SYS USER_UPDATABLE_COLUMNS
SYS USER_USERS
SYS USER_USTATS
SYS USER_VARRAYS
SYS USER_VIEWS
SYS USER_VIEWS_AE
SYS USER_WARNING_SETTINGS
SYS USER_XDS_ATTRIBUTE_SECS
SYS USER_XDS_INSTANCE_SETS
SYS USER_XDS_OBJECTS
SYS USER_XML_COLUMN_NAMES
SYS USER_XML_INDEXES
SYS USER_XML_SCHEMAS
SYS USER_XML_TABLES
SYS USER_XML_TAB_COLS
SYS USER_XML_VIEWS
SYS USER_XML_VIEW_COLS
SYS ALL_USERS
SYS DM_USER_MODELS
SYS ALL_REPCAT_USER_AUTHORIZATIONS
SYS ALL_REPCAT_USER_PARM_VALUES
SYS USER_MEASURE_FOLDERS
SYS USER_MEASURE_FOLDER_CONTENTS
SYS USER_METHOD_PARAMS
SYS USER_METHOD_RESULTS
SYS USER_MINING_MODELS
SYS USER_MINING_MODEL_ATTRIBUTES
SYS USER_MINING_MODEL_SETTINGS
SYS USER_MVIEWS
SYS USER_MVIEW_AGGREGATES
SYS USER_MVIEW_ANALYSIS
SYS USER_MVIEW_COMMENTS
SYS USER_MVIEW_DETAIL_PARTITION
SYS USER_MVIEW_DETAIL_RELATIONS
SYS USER_MVIEW_DETAIL_SUBPARTITION
SYS USER_MVIEW_JOINS
SYS USER_MVIEW_KEYS
SYS USER_MVIEW_LOGS
SYS USER_MVIEW_REFRESH_TIMES
SYS USER_NESTED_TABLES
SYS USER_NESTED_TABLE_COLS
SYS USER_NETWORK_ACL_PRIVILEGES
SYS USER_OBJECTS
SYS USER_OBJECTS_AE
SYS USER_OBJECT_SIZE
SYS USER_OBJECT_TABLES
SYS USER_OBJ_AUDIT_OPTS
SYS USER_OBJ_COLATTRS
SYS USER_OLDIMAGE_COLUMNS
SYS USER_OPANCILLARY
SYS USER_OPARGUMENTS
SYS USER_OPBINDINGS
SYS USER_OPERATORS
SYS USER_OPERATOR_COMMENTS
SYS USER_OUTLINES
SYS USER_OUTLINE_HINTS
SYS USER_PARALLEL_EXECUTE_CHUNKS
SYS USER_PARALLEL_EXECUTE_TASKS
SYS USER_PARTIAL_DROP_TABS
SYS USER_PART_COL_STATISTICS
SYS USER_PART_HISTOGRAMS
SYS USER_PART_INDEXES
SYS USER_PART_KEY_COLUMNS
SYS USER_PART_LOBS
SYS USER_PART_TABLES
SYS USER_PASSWORD_LIMITS
SYS USER_PENDING_CONV_TABLES
SYS USER_PLSQL_OBJECT_SETTINGS
SYS USER_POLICIES
SYS USER_POLICY_CONTEXTS
SYS USER_POLICY_GROUPS
SYS USER_PROCEDURES
SYS USER_PROXIES
SYS USER_PUBLISHED_COLUMNS
SYS USER_QUEUES
SYS USER_QUEUE_PUBLISHERS
SYS USER_QUEUE_SCHEDULES
SYS USER_QUEUE_SUBSCRIBERS
SYS USER_QUEUE_TABLES
SYS USER_RECYCLEBIN
SYS USER_REFRESH
SYS USER_REFRESH_CHILDREN
SYS USER_REFS
SYS USER_REGISTERED_MVIEWS
SYS USER_REGISTERED_SNAPSHOTS
SYS USER_REGISTRY
SYS USER_REPAUDIT_ATTRIBUTE
SYS USER_REPAUDIT_COLUMN
SYS USER_REPCAT
SYS USER_REPCATLOG
SYS USER_REPCAT_REFRESH_TEMPLATES
SYS USER_REPCAT_TEMPLATE_OBJECTS
SYS USER_REPCAT_TEMPLATE_PARMS
SYS USER_REPCAT_TEMPLATE_SITES
SYS USER_REPCAT_USER_AUTHORIZATION
SYS USER_REPCAT_USER_PARM_VALUES
SYS USER_REPCOLUMN
SYS USER_REPCOLUMN_GROUP
SYS USER_REPCONFLICT
SYS USER_REPDDL
SYS USER_REPFLAVORS
SYS USER_REPFLAVOR_COLUMNS
SYS USER_REPFLAVOR_OBJECTS
SYS USER_REPGENERATED
SYS USER_REPGENOBJECTS
SYS USER_REPGROUP
SYS USER_REPGROUPED_COLUMN
SYS USER_REPGROUP_PRIVILEGES
SYS USER_REPKEY_COLUMNS
SYS USER_REPOBJECT
SYS KU$_USER_PREF_STATS_VIEW
SYS KU$_USER_VIEW
SYS USER_CUBES
SYS USER_CUBE_ATTRIBUTES
SYS USER_CUBE_ATTR_VISIBILITY
SYS USER_CUBE_BUILD_PROCESSES
SYS USER_CUBE_CALCULATED_MEMBERS
SYS USER_CUBE_DIMENSIONALITY
SYS USER_CUBE_DIMENSIONS
SYS USER_CUBE_DIM_LEVELS
SYS USER_CUBE_DIM_MODELS
SYS USER_CUBE_DIM_VIEWS
SYS USER_CUBE_DIM_VIEW_COLUMNS
SYS USER_CUBE_HIERARCHIES
SYS USER_CUBE_HIER_LEVELS
SYS USER_CUBE_HIER_VIEWS
SYS USER_CUBE_HIER_VIEW_COLUMNS
SYS USER_CUBE_MEASURES
SYS USER_CUBE_VIEWS
SYS USER_CUBE_VIEW_COLUMNS
SYS USER_DATAPUMP_JOBS
SYS USER_DBFS_HS
SYS USER_DBFS_HS_COMMANDS
SYS USER_DBFS_HS_FILES
SYS USER_DBFS_HS_FIXED_PROPERTIES
SYS USER_DBFS_HS_PROPERTIES
SYS USER_DB_LINKS
SYS USER_DEPENDENCIES
SYS USER_DIMENSIONS
SYS USER_DIM_ATTRIBUTES
SYS USER_DIM_CHILD_OF
SYS USER_DIM_HIERARCHIES
SYS USER_DIM_JOIN_KEY
SYS USER_DIM_LEVELS
SYS USER_DIM_LEVEL_KEY
SYS USER_EDITIONING_VIEWS
SYS USER_EDITIONING_VIEWS_AE
SYS USER_EDITIONING_VIEW_COLS
SYS USER_EDITIONING_VIEW_COLS_AE
SYS USER_ENCRYPTED_COLUMNS
SYS USER_EPG_DAD_AUTHORIZATION
SYS USER_ERRORS
SYS USER_ERRORS_AE
SYS USER_EVALUATION_CONTEXTS
SYS USER_EVALUATION_CONTEXT_TABLES
SYS USER_EVALUATION_CONTEXT_VARS
SYS USER_EXTENTS
SYS USER_EXTERNAL_LOCATIONS
SYS USER_EXTERNAL_TABLES
SYS USER_FILE_GROUPS
SYS USER_FILE_GROUP_EXPORT_INFO
SYS USER_FILE_GROUP_FILES
SYS USER_FILE_GROUP_TABLES
SYS USER_FILE_GROUP_TABLESPACES
SYS USER_FILE_GROUP_VERSIONS
SYS USER_FLASHBACK_ARCHIVE
SYS USER_FLASHBACK_ARCHIVE_TABLES
SYS USER_FLASHBACK_TXN_REPORT
SYS USER_FLASHBACK_TXN_STATE
SYS USER_FREE_SPACE
SYS USER_GOLDENGATE_PRIVILEGES
SYS USER_IDENTIFIERS
SYS USER_INDEXES
SYS USER_INDEXTYPES
SYS USER_INDEXTYPE_ARRAYTYPES
SYS USER_INDEXTYPE_COMMENTS
SYS USER_INDEXTYPE_OPERATORS
SYS USER_IND_COLUMNS
SYS USER_IND_EXPRESSIONS
SYS USER_IND_PARTITIONS
SYS USER_IND_PENDING_STATS
SYS USER_IND_STATISTICS
SYS USER_IND_SUBPARTITIONS
SYS USER_INTERNAL_TRIGGERS
SYS USER_JAVA_ARGUMENTS
SYS USER_JAVA_CLASSES
SYS USER_JAVA_COMPILER_OPTIONS
SYS USER_JAVA_DERIVATIONS
SYS USER_JAVA_FIELDS
SYS USER_JAVA_IMPLEMENTS
SYS USER_JAVA_INNERS
SYS USER_JAVA_LAYOUTS
SYS USER_JAVA_METHODS
SYS USER_JAVA_NCOMPS
SYS USER_JAVA_POLICY
SYS USER_JAVA_RESOLVERS
SYS USER_JAVA_THROWS
SYS USER_JOBS
SYS USER_JOIN_IND_COLUMNS
SYS USER_LIBRARIES
SYS USER_LOBS
SYS USER_LOB_PARTITIONS
SYS USER_LOB_SUBPARTITIONS
SYS USER_LOB_TEMPLATES
SYS USER_LOG_GROUPS
SYS USER_LOG_GROUP_COLUMNS
WMSYS USER_MP_GRAPH_WORKSPACES
WMSYS USER_MP_PARENT_WORKSPACES
WMSYS USER_REMOVED_WORKSPACES
WMSYS USER_WM_CONSTRAINTS
WMSYS USER_WM_CONS_COLUMNS
WMSYS USER_WM_IND_COLUMNS
WMSYS USER_WM_IND_EXPRESSIONS
WMSYS USER_WM_LOCKED_TABLES
WMSYS USER_WM_MODIFIED_TABLES
WMSYS USER_WM_PRIVS
WMSYS USER_WM_RIC_INFO
WMSYS USER_WM_TAB_TRIGGERS
WMSYS USER_WM_VERSIONED_TABLES
WMSYS USER_WM_VT_ERRORS
WMSYS USER_WORKSPACES
WMSYS USER_WORKSPACE_PRIVS
WMSYS USER_WORKSPACE_SAVEPOINTS
SYS _USER_COMPARISON_ROW_DIF
SYS USER_REPPARAMETER_COLUMN
SYS USER_REPPRIORITY
SYS USER_REPPRIORITY_GROUP
SYS USER_REPPROP
SYS USER_REPRESOLUTION
SYS USER_REPRESOLUTION_METHOD
SYS USER_REPRESOLUTION_STATISTICS
SYS USER_REPRESOL_STATS_CONTROL
SYS USER_REPSCHEMA
SYS USER_REPSITES
SYS USER_RESOURCE_LIMITS
SYS USER_RESUMABLE
SYS USER_REWRITE_EQUIVALENCES
SYS USER_ROLE_PRIVS
SYS USER_RSRC_CONSUMER_GROUP_PRIVS
SYS USER_RSRC_MANAGER_SYSTEM_PRIVS
SYS USER_RULES
SYS USER_RULESETS
SYS USER_RULE_SETS
SYS USER_RULE_SET_RULES
SYS USER_SCHEDULER_CHAINS
SYS USER_SCHEDULER_CHAIN_RULES
SYS USER_SCHEDULER_CHAIN_STEPS
SYS USER_SCHEDULER_CREDENTIALS
SYS USER_SCHEDULER_DB_DESTS
SYS USER_SCHEDULER_DESTS
SYS USER_SCHEDULER_FILE_WATCHERS
SYS USER_SCHEDULER_GROUPS
SYS USER_SCHEDULER_GROUP_MEMBERS
SYS USER_SCHEDULER_JOBS
SYS USER_SCHEDULER_JOB_ARGS
SYS USER_SCHEDULER_JOB_DESTS
SYS USER_SCHEDULER_JOB_LOG
SYS USER_SCHEDULER_JOB_RUN_DETAILS
SYS USER_SCHEDULER_NOTIFICATIONS
SYS USER_SCHEDULER_PROGRAMS
SYS USER_SCHEDULER_PROGRAM_ARGS
SYS USER_SCHEDULER_REMOTE_JOBSTATE
SYS USER_SCHEDULER_RUNNING_CHAINS
SYS USER_SCHEDULER_RUNNING_JOBS
SYS USER_SCHEDULER_SCHEDULES
SYS USER_SECONDARY_OBJECTS
SYS USER_SEC_RELEVANT_COLS
SYS USER_SEGMENTS
SYS USER_SEQUENCES
SYS USER_SNAPSHOTS
SYS USER_SNAPSHOT_LOGS
SYS USER_SOURCE
SYS USER_SOURCE_AE
SYS USER_SOURCE_TABLES
SYS USER_SQLJ_TYPES
SYS USER_SQLJ_TYPE_ATTRS
SYS USER_SQLJ_TYPE_METHODS
SYS USER_SQLSET
SYS USER_SQLSET_BINDS
SYS USER_SQLSET_PLANS
SYS USER_SQLSET_REFERENCES
SYS USER_SQLSET_STATEMENTS
SYS USER_SQLTUNE_BINDS
SYS USER_SQLTUNE_PLANS
SYS USER_SQLTUNE_RATIONALE_PLAN
SYS USER_SQLTUNE_STATISTICS
SYS USER_STAT_EXTENSIONS
SYS USER_STORED_SETTINGS
SYS USER_SUBPARTITION_TEMPLATES
SYS USER_SUBPART_COL_STATISTICS
SYS USER_SUBPART_HISTOGRAMS
SYS USER_SUBPART_KEY_COLUMNS
SYS USER_SUBSCRIBED_COLUMNS
SYS USER_SUBSCRIBED_TABLES
SYS USER_SUBSCRIPTIONS
SYS USER_SUBSCR_REGISTRATIONS
SYS USER_SUMMARIES
SYS USER_SUMMARY_AGGREGATES
SYS USER_SUMMARY_DETAIL_TABLES
SYS USER_SUMMARY_JOINS
SYS USER_SUMMARY_KEYS
EXFSYS USER_EXPFIL_ASET_FUNCTIONS
EXFSYS USER_EXPFIL_ATTRIBUTES
EXFSYS USER_EXPFIL_ATTRIBUTE_SETS
EXFSYS USER_EXPFIL_DEF_INDEX_PARAMS
EXFSYS USER_EXPFIL_EXPRESSION_SETS
EXFSYS USER_EXPFIL_EXPRSET_STATS
EXFSYS USER_EXPFIL_INDEXES
EXFSYS USER_EXPFIL_INDEX_PARAMS
EXFSYS USER_EXPFIL_PREDTAB_ATTRIBUTES
EXFSYS USER_EXPFIL_PREDTAB_PLAN
EXFSYS USER_EXPFIL_PRIVILEGES
EXFSYS USER_EXPFIL_XPATH_TAGS
EXFSYS USER_RLM4J_ATTRIBUTE_ALIASES
EXFSYS USER_RLM4J_EVTST
EXFSYS USER_RLM4J_RULECLASSES
EXFSYS USER_RLMGR_ACTION_ERRORS
EXFSYS USER_RLMGR_COMPRCLS_PROPERTIES
EXFSYS USER_RLMGR_EVENT_STRUCTS
EXFSYS USER_RLMGR_PRIVILEGES
EXFSYS USER_RLMGR_RULE_CLASSES
EXFSYS USER_RLMGR_RULE_CLASS_STATUS
|
