课程第19次（2017-04-13星期四）

botang · 发表于 2017-4-14 09:32:29

上完1Z0-053闪回1
1Z0-052共19章（上完10章），1Z0-053共21章（上完3章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的13章
http://124.16.180.178:8080/studentguide_sec_O11g/1Z0-053-10/

游客，本帖隐藏的内容需要积分高于 100 才可浏览，您当前积分为 0

select * from flashback_transaction_query f
where f.table_name='T_NOCASCADE_FORCE' and f.table_owner='HR'
order by 4 desc;
begin
dbms_flashback.transaction_backout(1,xid_array('080013008B080000'),
options =>dbms_flashback.nocascade_force
);
end;
select * from hr.t_nocascade_force;
select * from dba_flashback_txn_report;
select * from dba_flashback_txn_state;
commit;
---
select * from hr.regions;
----
select * from dba_flashback_archive;
select * from dba_flashback_archive_tables;
select * from dba_flashback_archive_ts;
create flashback archive fda1
tablespace users quota 10M retention 1 year;
create flashback archive default fda2
tablespace users quota 20M retention 2 year;
alter flashback archive fda1 set default;
grant flashback archive on fda1 to hr;
select * from dba_objects o where o.owner='HR'
and o.object_name='EMPLOYEES';
create undo tablespace undotbs1 datafile size 10M ;
alter system set undo_tablespace=undotbs1;
drop tablespace undotbs2;
alter table hr.employees no flashback archive;
alter system flush buffer_cache;
----
create tablespace tbsfda datafile size 20M ;
alter flashback archive fda1 add tablespace tbsfda quota 10M ;
---
alter flashback archive fda1 modify retention 5 year;
alter flashback archive fda1 modify tablespace tbsfda quota 15M;
---
ALTER FLASHBACK ARCHIVE fda2
PURGE BEFORE
TIMESTAMP (SYSTIMESTAMP - INTERVAL '0 00:01:00' DAY TO SECOND);
select sysdate - INTERVAL '0 00:00:5' DAY TO SECOND, sysdate
from dual;
---
grant flashback archive on fda2 to hr;
select * from hr.SYS_FBA_HIST_73953;
alter system flush buffer_cache;
----
drop flashback archive fda2 ;
---
create flashback archive fda3
tablespace tbsfda quota 15M retention 10 day;
select * from dba_flashback_archive;
select * from dba_flashback_archive_tables;
select * from dba_flashback_archive_ts;
create table hr.part1 ( a number , b varchar2(20))
partition by range(a)
(
partition p1 values less than ( 100 ),
partition p2 values less than (maxvalue ));
insert into hr.part1 values (100,'AAA');
commit;
insert into hr.part1 values (49,'BBB');
commit;
select * from hr.part1 partition (p2);
select to_char(sysdate,'YYYY-MM-DD:HH24:MI:SS') from dual;
grant flashback archive on fda3 to hr;
alter table hr.part1 flashback archive fda3;
update hr.part1 set a=101 where a=100;
commit;
alter table hr.part1 drop (b) ;
select versions_xid , versions_startscn , versions_operation , a
from hr.part1
versions between timestamp sysdate-3/1440 and sysdate;
select * from hr.part1
as of scn 4199417;
alter table hr.part1 enable row movement;
flashback table hr.part1 to scn 4199417;
alter table hr.part1 split partition p1 at (50)
into ( partition p1_1 , partition p1_2 );
select * from hr.SYS_FBA_HIST_76026;
update hr.SYS_FBA_HIST_76026 set a=99 where a=100;
commit;
begin
dbms_flashback_archive.disassociate_fba('HR','PART1');
end;
begin
dbms_flashback_archive.reassociate_fba('HR','PART1');
end;
select * from dba_segments where segment_name='PART1';
select * from hr.part1 partition (p2);

复制代码