表空间改进源代码.docxVIP

表空间改进源代码 sql/plus /nolog conn sys/ldm as sysdba; create tablespace tybs01 datafile f:\tytbs01_1.dbf size 2M,f:/tytbs01_2.dbf size 2M autoallocate segment space management auto; create user tyuser2 identified by ldm default tablespece tybs01 quta 4M on tytbs01; alter user tyuser2 quota 2M on tytbs01; select a.tablespace_name ,a.bytes bytes, a.bytes-sum(nvl(b.bytes,0)) used, sum(nvl(b.bytes,0)) freee, sum(nvl(b.bytes,0))a.bytes*1000 %free 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