Curious Developing

- Gather(통계수집 실행 ) -> ALL(전체) : DBMS_UTILITY.[ANALYZE_DATABASE / ANALYZE_SCHEMA] -> By table(테이블별) : DBMS_STATS.gather_table_stats (ex) exec dbms_stats.gather_table_stats(ownname=> 'HR', tabname => 'DEPT', cascade => TRUE, block_sample=>false , method_opt=>'for all columns size 1', granularity=>'GLOBAL', no_invalidate=> FALSE, estimate_percent => 0.01, degree=>16); - 확인 -> Table : select table_n..

딕셔너리(List of Dictionaries) : SELECT * FROM dict; 오브젝트 타입(List of Object Types) : INDEX, JOB CLASS, CONTEXT, TABLE SUBPARTITION, TYPE BODY, INDEXTYPE, DESTINATION, PROCEDURE, JAVA CLASS, RULE, SCHEDULE, TABLE PARTITION, WINDOW, JAVA RESOURCE, TABLE, TYPE, VIEW, LIBRARY, FUNCTION, TRIGGER, PROGRAM, MATERIALIZED VIEW, JAVA SOURCE, CLUSTER, SYNONYM, PACKAGE BODY, CONSUMER GROUP, EVALUATION CONTEXT, ..

[data unload] print " set long 99999999 set feedback off set pagesize 0 set linesize 2000 set tab off set define off alter session set nls_date_format = 'yyyymmdd'; SELECT A, B, C_clob, D FROM {Schema}.{table} WHERE A BETWEEN '20130901' AND '20130931';" | sqlplus -s {id}/{pw} > {data_file}.dat [ctl File] LOAD DATA INFILE * APPEND INTO TABLE {schema}.{table_name} FIELDS TERMINATED BY '^|' TRAILIN..