SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BIN$Bnc5lHWi9ALgUAB/AQActw==$0 TABLE
BIN$CmN1Dij4JNzgUAB/AQAKKg==$0 TABLE
BIN$CmN1Dij5JNzgUAB/AQAKKg==$0 TABLE
BIN$CmNu0NooARXgUAB/AQAKEw==$0 TABLE
BIN$CmNu0NopARXgUAB/AQAKEw==$0 TABLE
BONUS TABLE
CAL TABLE
DAECHUL TABLE
DEPARTMENT TABLE
DEPT TABLE
DEPT2 TABLE
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
EMP TABLE
EMP2 TABLE
EXAM_01 TABLE
FRUIT TABLE
GIFT TABLE
GOGAK TABLE
HAKJUM TABLE
JUMSU TABLE
MEMBER TABLE
PANMAE TABLE
PLAN_TABLE TABLE
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
PRODUCT TABLE
PROFESSOR TABLE
PT_01 TABLE
PT_02 TABLE
P_01 TABLE
P_02 TABLE
P_GRADE TABLE
P_TOTAL TABLE
REG_TEST TABLE
REG_TEST2 TABLE
SALGRADE TABLE
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
STUDENT TABLE
TEST_ENABLE TABLE
TEST_NOVALIDATE TABLE
TEST_VALIDATE TABLE
TT100 TABLE
TT200 TABLE
TT300 TABLE
40 rows selected.
'DB > sql' 카테고리의 다른 글
sql*plus autotrace 기능 활성화 (0) | 2014.12.24 |
---|---|
튜닝에 필요한 파일들 (0) | 2014.12.22 |
인덱스 2 (0) | 2014.12.19 |
인덱스 1 (0) | 2014.12.19 |
redolog file 상태확인 (0) | 2014.12.03 |