课程第22/23次（2018-07-30星期一，2018-8-03星期五）

botang

11g 临时表空间特性：

1. select  sum(bytes)/1024/1024  from dba_temp_files where tablespace_name='TEMP';
   
2. 
   
3. select  * from dba_temp_free_space  fs where fs.tablespace_name='TEMP';
   
4. 
   
5. select  * from v$temp_extent_pool;
   
6. 
   
7. alter tablespace temp shrink space ;

复制代码

1. select   * from dba_tablespaces;
   
2. 
   
3. create tablespace tbsfbda datafile
   
4. '/u01/app/oracle/oradata/orcl/tbsfbda.dbf' size 10M  autoextend off;
   
5. 
   
6. select  * from dba_flashback_archive;
   
7. 
   
8. create flashback archive fbda1 tablespace tbsfbda
   
9. quota 3M  retention  2 year;
   
10. 
    
11. select * from dba_flashback_archive_ts;
    
12. 
    
13. select  * from dba_flashback_archive_tables;
    
14. 
    
15. grant flashback archive on fbda1 to hr;
    
16. 
    
17. alter table hr.employees  flashback archive fbda1;
    
18. 
    
19. select  object_id from dba_objects o where o.owner='HR'
    
20.   and o.object_name='EMPLOYEES';
    
21. 
    
22. select  * from hr.sys_fba_hist_92593;
    
23. 
    
24. alter flashback archive fbda1 set default;
    
25. 
    
26.   select  * from dba_flashback_archive;

复制代码

---HR:

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 30 20:48:08 2018
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn hr/oracle_4U
   
8. Connected.
   
9. SQL> select salary from employees where employee_id=100;
   
10. 
    
11.     SALARY
    
12. ----------
    
13.      24000
    
14. 
    
15. SQL> desc dbms_flashback
    
16. ERROR:
    
17. ORA-04043: object "SYS"."DBMS_FLASHBACK" does not exist
    
18. 
    
19. 
    
20. SQL> update employees set salary=25000 where employee_id=100;
    
21. 
    
22. 1 row updated.
    
23. 
    
24. SQL> commit;
    
25. 
    
26. Commit complete.
    
27. 
    
28. SQL>
    
29. SQL>
    
30. SQL> select versions_xid, versions_startscn , versions_operation , salary from employees
    
31.   2   versions between scn minvalue and maxvalue
    
32.   3   where employee_id=100;
    
33. 
    
34. VERSIONS_XID         VERSIONS_STARTSCN V         SALARY
    
35. ---------------- ----------------- - ----------
    
36.                                           24000
    
37. 0900100022150000           4224164 U          25000
    
38. 
    
39. SQL> select  salary from employees as of scn 4224163  where employee_id=100;
    
40. 
    
41.     SALARY
    
42. ----------
    
43.      24000
    
44. 
    
45. SQL>
    
46. 
    

复制代码

1. alter tablespace undotbs2 add datafile   '/u01/app/oracle/oradata/orcl/undotbs2.dbf'
   
2. size 30M autoextend on;
   
3. 
   
4. select * from dba_data_files;
   
5. 
   
6. select  * from dba_flashback_archive_tables;
   
7. 
   
8. select  count(*)  from hr.SYS_FBA_HIST_73953;
   
9. 
   
10. select  sum(bytes)/1024/1024  from dba_data_files df
    
11. where df.tablespace_name='TBSFBDA';
    
12. 
    
13. 
    
14. select    s.bytes/1024/1024
    
15.    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. 
   
8. 
   
9. SQL>
   

复制代码