（52-37）第56次，2015-03-18星期五

botang · 发表于 2016-3-19 11:39:08

（52-37）上完1Z0-053第18章：

select s.bytes/1024/1024
from dba_segments s
where s.owner='HR' and s.segment_name='T04209_UNAME' ;
select *
from dba_indexes i where
i.owner='HR' and i.table_name='IOT1';
select *
from dba_ind_columns ic
where ic.index_owner='HR' and ic.index_name='IOT1_INDEX1';
select t.row_movement
from dba_tables t where t.owner='HR' and t.table_name='T04209_UNAME';
select * from dba_segments s where s.owner='HR'
and s.segment_name='TLOB1';
select * from dba_lobs l where l.owner='HR'
and l.table_name='TLOB1';
grant resumable to hr;
drop tablespace tbs16K including contents ;
create tablespace tbs0518_resum
datafile '/home/oracle/tbs0518_resum.dbf' size 5M autoextend off;
select * from dba_data_files f
where f.tablespace_name='TBS0518_RESUM';
create or replace trigger trg05318_limit
after suspend
on database
declare
v_size number;
pragma AUTONOMOUS_TRANSACTION;
begin
select BYTES into v_size from dba_data_files where FILE_ID=10;
execute immediate 'alter database datafile 10 resize '||to_char(v_size+5242880);
commit;
end;
select * from dba_triggers t
where t.owner='SYS' and t.trigger_name='TRG05318_LIMIT';

复制代码