오라클 테이블 목록, 테이블 컬럼, 인덱스 목록, 인덱스컬럼, 테이블 스페이스

SET LINESIZE 1000;

SET PAGESIZE 10000;

SELECT * FROM USER_TABLES ORDER BY TABLE_NAME;

COL DATA_TYPE FORMAT A50;

SELECT * FROM USER_TAB_COLUMNS ORDER BY TABLE_NAME;

SELECT * FROM USER_TAB_PARTITIONS ORDER BY TABLE_NAME;

SELECT * FROM USER_INDEXES ORDER BY TABLE_NAME;

COL COLUMN_NAME FORMAT A50;

SELECT * FROM USER_IND_COLUMNS ORDER BY TABLE_NAME, INDEX_NAME, COLUMN_POSITION;

SELECT * FROM USER_IND_PARTITIONS;