《表空间改进源代码.docx》由会员分享，可在线阅读，更多相关《表空间改进源代码.docx（1页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、表空间改进源代码sql/plus /nologconn sys/ldm as sysdba;create tablespace tybsOldatafile f:tytbsOl_l.dbf size 2M；f:/tytbs01_2.dbf size 2M autoallocatesegment space management auto;create user tyuser2 identified by 1dm default tablespece tybsOl quta 4M on tytbsO 1;alter user tyuser2quota 2M on tytbsO 1;select
2、a.tablespace_name ,a.bytes bytes, a.bytes-sum(nvl(b.bytes,O) nusedn, sum(nvl(b.bytes,O) nfreeen,sum(nvl(b.bytes,0)a.bytes* 1000 n%freeH from dba_data_file a,dba_free_space b where a.file_id = b.file_id(+)group by a.tablespace_name a,a.bytes order by a.tablespace_name;alter databasedatafile T:tytbsOl_ldbf resize 6M;select tablespace _name tbs_name file_name, bytes/1024/1024 Mbytesfrom dba_data_fileswhere tablesepace_name + TYTBS01;