获取Tablespace的DDL
<DIV>select 'create tablespace ' || df.tablespace_name || chr(10)<BR> || ' datafile ''' || df.file_name || ''' size ' || df.bytes <BR> || decode(autoextensible,'N',null, chr(10) || ' autoextend on maxsize ' <BR> || maxbytes) <BR> || chr(10) <BR> || 'default storage ( initial ' || initial_extent <BR> || decode (next_extent, null, null, ' next ' || next_extent )<BR> || ' minextents ' || min_extents<BR> || ' maxextents ' || decode(max_extents,'2147483645','unlimited',max_extents) <BR> || ') ;'<BR> from dba_data_files df, dba_tablespaces t<BR> where df.tablespace_name=t.tablespace_name <BR>/</DIV>
页:
[1]