2014-06-30-2.sql

botang

select  * from dba_segments s
where s.segment_name='DEPARTMENTS' and s.owner='HR';

select  * from dba_extents e
where e.segment_name='DEPARTMENTS' and e.owner='HR';

select * from dba_tablespaces  t  where  t.segment_space_management = 'MANUAL';

select  * from v$tablespace;

select * from dba_tablespaces  t;


drop tablespace TBSJMW  including contents and datafiles;

create tablespace tbs05207_auto ;

create tablespace tbs05207_manual  segment space management manual;

select  * from dba_free_space;




select  * from dba_tablespaces  t where t.tablespace_name  like 'TBS05207%';

select * from dba_tables t where t.owner='HR'  and t.table_name like 'T05207%';

select  * from dba_extents e where e.owner='HR' and e.segment_name  like 'T05207%';

select  * from dba_tablespaces t where t.tablespace_name='TEMP';

create tablespace tbs05207_uniform datafile size 10M uniform size 512K;

select  * from dba_extents e where e.owner='HR' and e.segment_name  = 'T04209_UNAME';