分区:
HR >col TABLE_NAME for a20
HR >col PARTITION_NAME for a20
HR >col TABLEspace_NAME for a15
HR >col FILE_NAME for a40
HR >select a.TABLE_NAME,a.PARTITION_NAME,a.TABLESPACE_NAME,b.FILE_NAME
from user_tab_partitions a,dba_data_files b where a.TABLESPACE_NAME=b.TABLESPACE_NAME;;
TABLE_NAME |PARTITION_NAME |TABLESPACE_NAME|FILE_NAME
--------------------|--------------------|---------------|---------------------------------
P_TIME |P20130817 |P20130817 |/u01/oradata2/hr/p20130817.dbf
P_TIME |P20130818 |P20130818 |/u01/oradata2/hr/p20130818.dbf
P_TIME |P20130819 |P20130819 |/u01/oradata2/hr/p20130819.dbf
TIME_RANGE_SALES |SALES_1998 |HR |/u01/oradata2/hr/hr.dbf
TIME_RANGE_SALES |SALES_1999 |HR |/u01/oradata2/hr/hr.dbf
TIME_RANGE_SALES |SALES_2001 |HR |/u01/oradata2/hr/hr.dbf
TIME_RANGE_SALES |SALES_2000 |HR |/u01/oradata2/hr/hr.dbf
对象:
HR >select OWNER,OBJECT_NAME,OBJECT_TYPE from dba_objects where OWNER='HR';
OWNER |OBJECT_NAME |OBJECT_TYPE
----------|------------------------------|-------------------
HR |EMPLOYEES_SEQ |SEQUENCE
HR |LOCATIONS_SEQ |SEQUENCE
HR |DEPARTMENTS_SEQ |SEQUENCE
HR |TEST_TYPE |TYPE
HR |COUNTRIES |TABLE
HR |COUNTRY_C_ID_PK |INDEX
HR |DEPARTMENTS |TABLE
HR |DEPT_ID_PK |INDEX
HR |EMPLOYEES |TABLE
HR |EMP_EMAIL_UK |INDEX
HR |EMP_EMP_ID_PK |INDEX
HR |JOBS |TABLE
HR |JOB_ID_PK |INDEX
HR |JOB_HISTORY |TABLE
HR |JHIST_EMP_ID_ST_DATE_PK |INDEX
HR |LOCATIONS |TABLE
HR |LOC_ID_PK |INDEX
HR |P_TIME |TABLE PARTITION
HR |P_TIME |TABLE PARTITION
HR |P_TIME |TABLE PARTITION
HR |P_TIME |TABLE
HR |REGIONS |TABLE
HR |REG_ID_PK |INDEX
HR |STUDENT |TABLE
HR |SYS_C006388 |INDEX
HR |STUDENT1 |TABLE
HR |SYS_C006390 |INDEX
HR |STUDENT2 |TABLE
HR |TEST_TABLE |TABLE
HR |SYS_C006392 |INDEX
HR |TIME_RANGE_SALES |TABLE PARTITION
HR |TIME_RANGE_SALES |TABLE PARTITION
HR |TIME_RANGE_SALES |TABLE PARTITION
HR |TIME_RANGE_SALES |TABLE PARTITION
HR |TIME_RANGE_SALES |TABLE
HR |EMP_DETAILS_VIEW |VIEW
HR |HR_PR3 |PROCEDURE
HR |HR_PR4 |PROCEDURE