oracle 查询创建表，表空间，表所属的表空间指令

查看创建表空间指令

SQL> select dbms_metadata.get_ddl('TABLESPACE','TOM') from dual;

DBMS_METADATA.GET_DDL('TABLESPACE','TOM')
-----------------------------------------------------------------------------

  CREATE TABLESPACE "TOM" DATAFILE
  'D:\DEV\ORACLEDATA\TEST\TOM01.DBF' SIZE 5

查询创建表指令
SQL> select dbms_metadata.get_ddl('TABLE','T1') from dual;

DBMS_METADATA.GET_DDL('TABLE','T1')
--------------------------------------------------------------------

  CREATE TABLE "SYS"."T1"
   (    "ID" NUMBER(*,0),
        "SCN" NUMBER,
        "NAME" VARC

查看一张表所属表空间;;
select TABLESPACE_NAME from all_tables where table_name='T1';