16.txt

Oracle database 10g基础教程（第二版） 源码

desc v$database

desc v$flashback_database_log

desc v$flashback_database_stat


 
connect system/manager
create user binUser
identified by binUser;
grant create session, dba
to binUser;


connect binUser/binUser
select table_name
from user_tables;
select object_name
from user_recyclebin;



create table bin_table
as
select * 
from dual;
select table_name
from user_tables;
drop table bin_table;



select table_name
from user_tables;
select object_name
from user_recyclebin;






create table bin_table
as
select * 
from dual;
select table_name
from user_tables;


drop table bin_table;
select object_name
from user_recyclebin;


purge table bin_table;
select object_name
from user_recyclebin;
purge table bin_table;
select object_name
from user_recyclebin;





create table bin_table
as
select * 
from dual;
drop table bin_table purge;
select object_name
from user_recyclebin;







create table bin_table
as
select * 
from dual;
drop table bin_table;





select object_name, original_name
from user_recyclebin;
flashback table bin_table to before drop;
select object_name, original_name
from user_recyclebin;



drop table bin_table;
flashback table bin_table to before drop rename to new_bin_table;
select table_name
from user_tables;



create table rates(
currency varchar2(4),
rate number(15, 10)
);
desc rates









insert into rates values ('日元',1.25);
commit;
update rates set rate = 1.28;
commit;
delete from rates;
commit;
insert into rates values ('日元',1.26);
commit;


select *
from rates;

set linesize 120
column versions_starttime format a30
column versions_endtime format a30
column versions_xid format a30
column versions_operation format a3
column rate format $999,999.00
select versions_starttime, versions_endtime, versions_xid, versions_operation, rate 
from rates 
versions between timestamp minvalue and maxvalue
order by versions_starttime;





select undo_sql
from flashback_transaction_query
where xid = '0700220070010000';




select rate, versions_starttime, versions_endtime
from rates 
versions between timestamp 
to_date('08/20/2008 16:45:26','mm/dd/yyyy hh24:mi:ss')
and to_date('08/20/2008 16:45:45','mm/dd/yyyy hh24:mi:ss');





desc flashback_transaction_query