Bo's Oracle Station

查看: 2158|回复: 0

第36次:2015-04-16星期四

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2015-4-17 09:33:32 | 显示全部楼层 |阅读模式


  1. select  * from dba_tablespaces;

  2. create tablespace tbsfda datafile size 50M autoextend on ;

  3. create flashback archive default  fda1
  4. tablespace tbsfda quota 100M  retention  10  year;

  5. select * from dba_flashback_archive;

  6. select  * from dba_flashback_archive_ts;

  7. select * from dba_flashback_archive_tables;

  8. select * from dba_sys_privs p where p.privilege like 'FLASH%';

  9. grant  flashback archive   on fda1  to hr;

  10. grant  flashback archive   on fda2  to hr;


  11. create flashback archive  fda2
  12. tablespace tbsfda quota 100M  retention  20  year;


  13. alter flashback archive fda2 set default;

  14. select * from dba_flashback_archive_tables;

  15. select  * from hr.SYS_FBA_HIST_78645;

  16. alter table hr.t05311_fda1 no flashback archive;


  17. select  * from hr.SYS_FBA_HIST_78646;
复制代码
  1. select  * from dba_recyclebin;

  2. select * from dba_segments s where s.segment_name like '%T05311_BIN2';

  3. select  * from dba_recyclebin;


  4. select  * from dba_indexes i where i.owner='HR' and i.table_name='T05311_BIN2';

  5. alter index  hr."BIN$E9e/ZQ8+DLvgUKjAWgBxZQ==$0" rename to pk_T05311_BIN2;

  6. select    sum(bytes)/1024/1024    from dba_data_files where tablespace_name='USERS';

  7. select  sum(bytes)/1024/1024   from dba_free_space where tablespace_name='USERS';

  8. purge tablespace users  user hr;

  9. purge tablespace users;
复制代码



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 02:43 , Processed in 0.037440 second(s), 24 queries .

快速回复 返回顶部 返回列表