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';