设为首页收藏本站

Botang唐波's Oracle Station

查看: 169|回复: 0

课程第22/23次(2018-07-30星期一,2018-8-03星期五)

[复制链接]

731

主题

1102

帖子

8002

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8002
发表于 2018-7-30 19:34:42 | 显示全部楼层 |阅读模式
11g 临时表空间特性:
  1. select  sum(bytes)/1024/1024  from dba_temp_files where tablespace_name='TEMP';

  2. select  * from dba_temp_free_space  fs where fs.tablespace_name='TEMP';

  3. select  * from v$temp_extent_pool;

  4. alter tablespace temp shrink space ;
复制代码


  1. select   * from dba_tablespaces;

  2. create tablespace tbsfbda datafile
  3. '/u01/app/oracle/oradata/orcl/tbsfbda.dbf' size 10M  autoextend off;

  4. select  * from dba_flashback_archive;

  5. create flashback archive fbda1 tablespace tbsfbda
  6. quota 3M  retention  2 year;

  7. select * from dba_flashback_archive_ts;

  8. select  * from dba_flashback_archive_tables;

  9. grant flashback archive on fbda1 to hr;

  10. alter table hr.employees  flashback archive fbda1;

  11. select  object_id from dba_objects o where o.owner='HR'
  12.   and o.object_name='EMPLOYEES';

  13. select  * from hr.sys_fba_hist_92593;

  14. alter flashback archive fbda1 set default;

  15.   select  * from dba_flashback_archive;
复制代码
---HR:
  1. [oracle@station90 ~]$ sqlplus /nolog

  2. SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 30 20:48:08 2018

  3. Copyright (c) 1982, 2011, Oracle.  All rights reserved.

  4. SQL> conn hr/oracle_4U
  5. Connected.
  6. SQL> select salary from employees where employee_id=100;

  7.     SALARY
  8. ----------
  9.      24000

  10. SQL> desc dbms_flashback
  11. ERROR:
  12. ORA-04043: object "SYS"."DBMS_FLASHBACK" does not exist


  13. SQL> update employees set salary=25000 where employee_id=100;

  14. 1 row updated.

  15. SQL> commit;

  16. Commit complete.

  17. SQL>
  18. SQL>
  19. SQL> select versions_xid, versions_startscn , versions_operation , salary from employees
  20.   2   versions between scn minvalue and maxvalue
  21.   3   where employee_id=100;

  22. VERSIONS_XID         VERSIONS_STARTSCN V         SALARY
  23. ---------------- ----------------- - ----------
  24.                                           24000
  25. 0900100022150000           4224164 U          25000

  26. SQL> select  salary from employees as of scn 4224163  where employee_id=100;

  27.     SALARY
  28. ----------
  29.      24000

  30. SQL>

复制代码
  1. alter tablespace undotbs2 add datafile   '/u01/app/oracle/oradata/orcl/undotbs2.dbf'
  2. size 30M autoextend on;

  3. select * from dba_data_files;

  4. select  * from dba_flashback_archive_tables;

  5. select  count(*)  from hr.SYS_FBA_HIST_73953;

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


  8. select    s.bytes/1024/1024
  9.    from dba_segments  s where segment_name='SYS_FBA_HIST_73953';
复制代码
  1. lashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  2. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  3. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  4. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  5. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  6. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  7. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  8. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  9. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  10. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  11. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  12. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  13. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  14. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  15. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  16. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  17. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  18. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  19. Tue Jul 31 07:19:19 2018
  20. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  21. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  22. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  23. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  24. Tue Jul 31 07:19:19 2018
  25. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  26. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  27. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  28. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  29. Tue Jul 31 07:19:22 2018
  30. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  31. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  32. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  33. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  34. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  35. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  36. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  37. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  38. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  39. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  40. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  41. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  42. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  43. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  44. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  45. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  46. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  47. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  48. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  49. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  50. Tue Jul 31 07:19:32 2018
  51. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  52. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  53. Tue Jul 31 07:19:32 2018
  54. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  55. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  56. Tue Jul 31 07:19:33 2018
  57. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  58. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  59. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  60. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  61. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  62. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  63. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  64. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  65. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  66. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  67. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  68. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  69. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  70. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  71. Tue Jul 31 07:19:42 2018
  72. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  73. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  74. Tue Jul 31 07:19:43 2018
  75. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  76. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  77. Tue Jul 31 07:19:43 2018
  78. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  79. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  80. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  81. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  82. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  83. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  84. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  85. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  86. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  87. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  88. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  89. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  90. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  91. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  92. Tue Jul 31 07:19:53 2018
  93. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  94. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  95. Tue Jul 31 07:19:54 2018
  96. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  97. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  98. Tue Jul 31 07:19:55 2018
  99. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  100. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  101. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  102. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  103. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  104. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  105. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  106. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  107. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  108. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  109. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  110. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  111. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  112. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  113. Tue Jul 31 07:20:05 2018
  114. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  115. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  116. Tue Jul 31 07:20:05 2018
  117. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  118. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  119. Tue Jul 31 07:20:09 2018
  120. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  121. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  122. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  123. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  124. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  125. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  126. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  127. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  128. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  129. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  130. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  131. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  132. Tue Jul 31 07:20:16 2018
  133. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  134. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  135. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  136. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  137. Tue Jul 31 07:20:17 2018
  138. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  139. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  140. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  141. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  142. Tue Jul 31 07:20:20 2018
  143. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  144. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  145. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  146. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  147. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  148. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  149. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  150. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  151. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  152. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  153. Tue Jul 31 07:20:27 2018
  154. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  155. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  156. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  157. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  158. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  159. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  160. Tue Jul 31 07:20:30 2018
  161. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  162. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  163. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  164. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  165. Tue Jul 31 07:20:31 2018
  166. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  167. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  168. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  169. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  170. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  171. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  172. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  173. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  174. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  175. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  176. Tue Jul 31 07:20:37 2018
  177. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  178. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  179. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  180. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  181. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  182. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  183. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  184. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  185. Tue Jul 31 07:20:42 2018
  186. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  187. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  188. Tue Jul 31 07:20:43 2018
  189. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  190. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  191. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  192. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  193. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  194. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  195. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  196. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  197. Tue Jul 31 07:20:47 2018
  198. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  199. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  200. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  201. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  202. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  203. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  204. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  205. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  206. Tue Jul 31 07:20:52 2018
  207. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  208. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  209. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  210. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  211. Tue Jul 31 07:20:54 2018
  212. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  213. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  214. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  215. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  216. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  217. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  218. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  219. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  220. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  221. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  222. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  223. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  224. Tue Jul 31 07:21:00 2018
  225. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  226. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  227. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  228. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  229. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  230. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  231. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  232. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  233. Tue Jul 31 07:21:05 2018
  234. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  235. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  236. Tue Jul 31 07:21:05 2018
  237. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  238. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  239. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  240. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  241. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  242. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  243. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  244. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  245. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  246. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  247. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  248. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  249. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  250. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  251. Tue Jul 31 07:21:12 2018
  252. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  253. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  254. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  255. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  256. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  257. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  258. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  259. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  260. Tue Jul 31 07:21:16 2018
  261. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  262. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  263. Tue Jul 31 07:21:17 2018
  264. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  265. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  266. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  267. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  268. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  269. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  270. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  271. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  272. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  273. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  274. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  275. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  276. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  277. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  278. Tue Jul 31 07:21:24 2018
  279. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  280. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  281. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  282. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  283. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  284. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  285. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  286. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  287. Tue Jul 31 07:21:28 2018
  288. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  289. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  290. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  291. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  292. Tue Jul 31 07:21:30 2018
  293. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  294. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  295. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  296. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  297. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  298. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  299. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  300. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  301. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  302. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  303. Tue Jul 31 07:21:35 2018
  304. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  305. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  306. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  307. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  308. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  309. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  310. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  311. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  312. Tue Jul 31 07:21:38 2018
  313. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  314. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  315. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  316. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  317. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  318. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  319. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  320. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  321. Tue Jul 31 07:21:42 2018
  322. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  323. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  324. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  325. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  326. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  327. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  328. Tue Jul 31 07:21:46 2018
  329. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  330. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  331. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  332. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  333. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  334. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  335. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  336. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  337. Tue Jul 31 07:21:49 2018
  338. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  339. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  340. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  341. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  342. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  343. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  344. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  345. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  346. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  347. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  348. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  349. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  350. Tue Jul 31 07:21:54 2018
  351. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  352. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  353. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  354. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  355. Tue Jul 31 07:21:57 2018
  356. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  357. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  358. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  359. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  360. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  361. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  362. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  363. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  364. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  365. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  366. Tue Jul 31 07:22:02 2018
  367. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  368. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  369. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  370. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  371. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  372. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  373. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  374. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  375. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  376. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  377. Tue Jul 31 07:22:08 2018
  378. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  379. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  380. Tue Jul 31 07:22:08 2018
  381. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  382. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
  383. Flashback Archive FBDA1 ran out of space in tablespace TBSFBDA.
  384. ORA-1688: unable to extend table HR.SYS_FBA_HIST_73953 partition HIGH_PART by 1024 in                 tablespace TBSFBDA
复制代码
  1. SQL> SQL> SQL> SQL> update employees set salary=60000 where employee_id=100;
  2. update employees set salary=60000 where employee_id=100
  3.        *
  4. ERROR at line 1:
  5. ORA-55617: Flashback Archive "FBDA1" runs out of space and tracking on
  6. "EMPLOYEES" is suspended


  7. SQL>
复制代码







回复

使用道具 举报

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

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-10-22 04:01 , Processed in 0.094958 second(s), 24 queries .

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