课程第21次（2017-08-22星期二）

botang

SQLPLUS:

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 22 19:39:50 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn hr/oracle_4U
   
8. Connected.
   
9. SQL> select  * from t_nonconflict_only;
   
10. 
    
11.         ID
    
12. ----------
    
13.         11
    
14.         22
    
15.        333
    
16. 
    
17. SQL> /
    
18. 
    
19.         ID
    
20. ----------
    
21.          1
    
22.         22
    
23.        333
    
24. 
    
25. SQL> select  * from t_nocascade_force;
    
26. 
    
27.         ID
    
28. ----------
    
29.          1
    
30.          2
    
31.        333
    
32. 
    
33. SQL> select  * from t_nocascade;
    
34. 
    
35.         ID
    
36. ----------
    
37.         11
    
38.         22
    
39.        333
    
40. 
    
41. SQL> @t05310-2
    
42. Enter value for s1: t_non
    
43. old   1: create table &&s1( id number )
    
44. new   1: create table t_non( id number )
    
45. 
    
46. Table created.
    
47. 
    
48. 
    
49. old   1: insert into &&s1 values (1)
    
50. new   1: insert into t_non values (1)
    
51. 
    
52. 1 row created.
    
53. 
    
54. old   1: insert into &&s1 values (2)
    
55. new   1: insert into t_non values (2)
    
56. 
    
57. 1 row created.
    
58. 
    
59. old   1: insert into &&s1 values (3)
    
60. new   1: insert into t_non values (3)
    
61. 
    
62. 1 row created.
    
63. 
    
64. 
    
65. Commit complete.
    
66. 
    
67. old   1: update &&s1 set id=11 where id=1
    
68. new   1: update t_non set id=11 where id=1
    
69. 
    
70. 1 row updated.
    
71. 
    
72. old   1: update &&s1 set id=22 where id=2
    
73. new   1: update t_non set id=22 where id=2
    
74. 
    
75. 1 row updated.
    
76. 
    
77. old   1: update &&s1 set id=33 where id=3
    
78. new   1: update t_non set id=33 where id=3
    
79. 
    
80. 1 row updated.
    
81. 
    
82. 
    
83. Commit complete.
    
84. 
    
85. old   1: update &&s1 set id=222 where id=22
    
86. new   1: update t_non set id=222 where id=22
    
87. 
    
88. 1 row updated.
    
89. 
    
90. old   1: update &&s1 set id=333 where id=33
    
91. new   1: update t_non set id=333 where id=33
    
92. 
    
93. 1 row updated.
    
94. 
    
95. 
    
96. Commit complete.
    
97. 
    
98. SQL> select  * from t_non;
    
99. 
    
100.         ID
     
101. ----------
     
102.          1
     
103.        222
     
104.        333
     
105. 
     
106. SQL> @t05310-2
     
107. Enter value for s1: t_nocf
     
108. old   1: create table &&s1( id number )
     
109. new   1: create table t_nocf( id number )
     
110. 
     
111. Table created.
     
112. 
     
113. 
     
114. old   1: insert into &&s1 values (1)
     
115. new   1: insert into t_nocf values (1)
     
116. 
     
117. 1 row created.
     
118. 
     
119. old   1: insert into &&s1 values (2)
     
120. new   1: insert into t_nocf values (2)
     
121. 
     
122. 1 row created.
     
123. 
     
124. old   1: insert into &&s1 values (3)
     
125. new   1: insert into t_nocf values (3)
     
126. 
     
127. 1 row created.
     
128. 
     
129. 
     
130. Commit complete.
     
131. 
     
132. old   1: update &&s1 set id=11 where id=1
     
133. new   1: update t_nocf set id=11 where id=1
     
134. 
     
135. 1 row updated.
     
136. 
     
137. old   1: update &&s1 set id=22 where id=2
     
138. new   1: update t_nocf set id=22 where id=2
     
139. 
     
140. 1 row updated.
     
141. 
     
142. old   1: update &&s1 set id=33 where id=3
     
143. new   1: update t_nocf set id=33 where id=3
     
144. 
     
145. 1 row updated.
     
146. 
     
147. 
     
148. Commit complete.
     
149. 
     
150. old   1: update &&s1 set id=222 where id=22
     
151. new   1: update t_nocf set id=222 where id=22
     
152. 
     
153. 1 row updated.
     
154. 
     
155. old   1: update &&s1 set id=333 where id=33
     
156. new   1: update t_nocf set id=333 where id=33
     
157. 
     
158. 1 row updated.
     
159. 
     
160. 
     
161. Commit complete.
     
162. 
     
163. SQL> select  * from t_nocf
     
164.   2  ;
     
165. 
     
166.         ID
     
167. ----------
     
168.         11
     
169.        222
     
170.        333
     
171. 
     
172. SQL> /
     
173. 
     
174.         ID
     
175. ----------
     
176.          1
     
177.        222
     
178.        333
     
179. 
     
180. SQL>
     
181. 
     

复制代码

PL/SQL：

1. 
   
2. alter database add  supplemental log data ;
   
3. 
   
4. alter database add  supplemental log data ( primary key ) columns;
   
5. 
   
6. select  * from flashback_transaction_query ftq
   
7. where ftq.table_name='T_NONCONFLICT_ONLY'  
   
8. and ftq.table_owner='HR'
   
9.   order by ftq.commit_scn desc ;
   
10. 
    
11. begin
    
12.     dbms_flashback.transaction_backout(1,
    
13.     xids =>sys.xid_array ('0300180076030000'),
    
14.     options => dbms_flashback.nonconflict_only);
    
15. end;
    
16. 
    
17. select  * from hr.t_nocascade;
    
18. select  * from hr.t_nonconflict_only;
    
19. 
    
20. ----
    
21. select  * from dba_flashback_txn_report;
    
22. 
    
23. select  * from dba_flashback_txn_state;
    
24. 
    
25. 
    
26. ---080009005C030000
    
27. 
    
28. commit;
    
29. -----
    
30. 
    
31. select  * from flashback_transaction_query ftq
    
32. where ftq.table_name='T_NOCASCADE_FORCE'  
    
33. and ftq.table_owner='HR'
    
34.   order by ftq.commit_scn desc ;
    
35. 
    
36. begin
    
37.     dbms_flashback.transaction_backout(1,
    
38.     xids =>sys.xid_array ('080014005C030000'),
    
39.     options => dbms_flashback.nocascade_force);
    
40. end;
    
41. 
    
42. select  * from hr.t_nocascade;
    
43. select  * from hr.t_nocascade_force;
    
44. 
    
45. ----
    
46. select  * from dba_flashback_txn_report;
    
47. 
    
48. select  * from dba_flashback_txn_state;
    
49. 
    
50. 
    
51. ---080009005C030000
    
52. 
    
53. commit;
    
54. 
    
55. --------------------
    
56. 
    
57. select  * from flashback_transaction_query ftq
    
58. where ftq.table_name='T_NON'  
    
59. and ftq.table_owner='HR'
    
60.   order by ftq.commit_scn desc ;
    
61. 
    
62. begin
    
63.     dbms_flashback.transaction_backout(1,
    
64.     xids =>sys.xid_array ('0600090061030000'),
    
65.     options => dbms_flashback.nonconflict_only);
    
66. end;
    
67. 
    
68. 
    
69. 
    
70. commit;
    
71. 
    
72. ----------
    
73. 
    
74. select  * from flashback_transaction_query ftq
    
75. where ftq.table_name='T_NOCF'  
    
76. and ftq.table_owner='HR'
    
77.   order by ftq.commit_scn desc ;
    
78. 
    
79. begin
    
80.     dbms_flashback.transaction_backout(1,
    
81.     xids =>sys.xid_array ('03001A007C030000'),
    
82.     options => dbms_flashback.nocascade_force);
    
83. end;
    
84.   
    
85. commit;

复制代码

1. select  * from dba_flashback_archive;
   
2. 
   
3. select  * from dba_flashback_archive_ts;
   
4. 
   
5. select * from dba_flashback_archive_tables;
   
6. 
   
7. create flashback archive fba1
   
8. tablespace users quota 10M  retention 10 day;

复制代码

SQLPLUS：

1. SQL> alter table employees flashback archive fba1;
   
2. alter table employees flashback archive fba1
   
3. *
   
4. ERROR at line 1:
   
5. ORA-55620: No privilege to use Flashback Archive
   
6. 
   
7. 
   
8. SQL> alter table employees flashback archive fba1;
   
9. 
   
10. Table altered.
    
11. 
    
12. SQL> select  object_id from user_objects
    
13.   2   where object_name='EMPLOYEES';
    
14. 
    
15. OBJECT_ID
    
16. ----------
    
17.      73953
    
18. 
    
19. SQL> select  * from hr.sys_fba_hist_73953;
    
20. select        * from hr.sys_fba_hist_73953
    
21.                   *
    
22. ERROR at line 1:
    
23. ORA-00942: table or view does not exist
    
24. 
    
25. 
    
26. SQL> select  salary from employees where employee_id=100;
    
27. 
    
28.     SALARY
    
29. ----------
    
30.      24000
    
31. 
    
32. SQL> update employees set salary=25000 where employee_id=100;
    
33. 
    
34. 1 row updated.
    
35. 
    
36. SQL> commit;
    
37. 
    
38. Commit complete.
    
39. 
    
40. SQL> select  * from hr.sys_fba_hist_73953;
    
41. select        * from hr.sys_fba_hist_73953
    
42.                   *
    
43. ERROR at line 1:
    
44. ORA-00942: table or view does not exist
    
45. 
    
46. 
    
47. SQL> /
    
48. 
    
49. RID
    
50. --------------------------------------------------------------------------------
    
51.   STARTSCN     ENDSCN XID               O EMPLOYEE_ID FIRST_NAME
    
52. ---------- ---------- ---------------- - ----------- --------------------
    
53. LAST_NAME                  EMAIL                     PHONE_NUMBER
    
54. ------------------------- ------------------------- --------------------
    
55. HIRE_DATE            JOB_ID           SALARY COMMISSION_PCT MANAGER_ID
    
56. ------------------- ---------- ---------- -------------- ----------
    
57. DEPARTMENT_ID
    
58. -------------
    
59. AAAR5pAAFAAAADPAAA
    
60.               1125736                                 100 Steven
    
61. King                          SKING                     515.123.4567
    
62. 
    
63. RID
    
64. --------------------------------------------------------------------------------
    
65.   STARTSCN     ENDSCN XID               O EMPLOYEE_ID FIRST_NAME
    
66. ---------- ---------- ---------------- - ----------- --------------------
    
67. LAST_NAME                  EMAIL                     PHONE_NUMBER
    
68. ------------------------- ------------------------- --------------------
    
69. HIRE_DATE            JOB_ID           SALARY COMMISSION_PCT MANAGER_ID
    
70. ------------------- ---------- ---------- -------------- ----------
    
71. DEPARTMENT_ID
    
72. -------------
    
73. 2003-06-17:00:00:00 AD_PRES            24000
    
74.            90
    
75. 
    
76. 
    
77. SQL> update hr.sys_fba_hist_73953 set SALARY=23000 ;
    
78. update hr.sys_fba_hist_73953 set SALARY=23000
    
79.           *
    
80. ERROR at line 1:
    
81. ORA-55622: DML, ALTER and CREATE UNIQUE INDEX operations are not allowed on
    
82. table "HR"."SYS_FBA_HIST_73953"
    
83. 
    
84. 
    
85. SQL>
    
86. 
    
87. 
    
88. 
    
89. 
    
90. 
    
91. 
    
92. 
    
93. 
    
94. 
    
95. 
    
96. 
    
97. 
    
98. SQL> create table t05311_a ( a  number , b varchar2(20))   ;
    
99. 
    
100. Table created.
     
101. 
     
102. SQL> show user
     
103. USER is "HR"
     
104. SQL> insert into t05311_a values ( 1   , 'A') ;
     
105. 
     
106. 1 row created.
     
107. 
     
108. SQL> commit;
     
109. 
     
110. Commit complete.
     
111. 
     
112. SQL> alter table t05311_a  flashback archive ;
     
113. 
     
114. Table altered.
     
115. 
     
116. SQL> select to_char(sysdate,'YYYY-MM-DD:HH24:MI:SS')  from dual;
     
117. 
     
118. TO_CHAR(SYSDATE,'YY
     
119. -------------------
     
120. 2017-08-22:21:00:24
     
121. 
     
122. SQL> update t05311_a set a=2 , b='B';
     
123. 
     
124. 1 row updated.
     
125. 
     
126. SQL> commit;
     
127. 
     
128. Commit complete.
     
129. 
     
130. SQL> select  * from sys_fba_hist_74619;
     
131. select        * from sys_fba_hist_74619
     
132.                *
     
133. ERROR at line 1:
     
134. ORA-00942: table or view does not exist
     
135. 
     
136. 
     
137. SQL> /
     
138. 
     
139. RID
     
140. --------------------------------------------------------------------------------
     
141.   STARTSCN     ENDSCN XID               O          A B
     
142. ---------- ---------- ---------------- - ---------- --------------------
     
143. AAASN7AAEAAAALWAAA
     
144.    1126744    1127241 03001C0080030000 I          1 A
     
145. 
     
146. 
     
147. SQL> select  * from t05311_a
     
148.   2   as of timestamp to_timestamp('2017-08-22:21:00:24','YYYY-MM-DD:HH24:MI:SS') ;
     
149. 
     
150.          A B
     
151. ---------- --------------------
     
152.          1 A
     
153. 
     
154. SQL> select  * from t05311_a
     
155.   2   as of scn 1127241;
     
156. 
     
157.          A B
     
158. ---------- --------------------
     
159.          2 B
     
160. 
     
161. SQL> select  * from t05311_a
     
162.   2  as of scn 1127240;
     
163. 
     
164.          A B
     
165. ---------- --------------------
     
166.          1 A
     
167. 
     
168. SQL> update t05311_a set a=3,b='C' ;
     
169. 
     
170. 1 row updated.
     
171. 
     
172. SQL> commit;
     
173. 
     
174. Commit complete.
     
175. 
     
176. SQL> update t05311_a set a=4,b='D' ;
     
177. 
     
178. 1 row updated.
     
179. 
     
180. SQL> commit;
     
181. 
     
182. Commit complete.
     
183. 
     
184. SQL>  select to_char(sysdate,'YYYY-MM-DD:HH24:MI:SS')  from dual;
     
185. 
     
186. TO_CHAR(SYSDATE,'YY
     
187. -------------------
     
188. 2017-08-22:21:11:55
     
189. 
     
190. SQL> alter table t05311_a drop ( b) ;
     
191. 
     
192. Table altered.
     
193. 
     
194. SQL> select  * from t05311_a;
     
195. 
     
196.          A
     
197. ----------
     
198.          4
     
199. 
     
200. SQL> update t05311_a set a=5 ;
     
201. 
     
202. 1 row updated.
     
203. 
     
204. SQL> commit;
     
205. 
     
206. Commit complete.
     
207. 
     
208. SQL> select  versions_xid, versions_operation , a, b from t05311_a
     
209.   2  versions between scn minvalue and maxvalue ;
     
210. 
     
211. VERSIONS_XID         V            A B
     
212. ---------------- - ---------- --------------------
     
213. 03001C0080030000 I            1 A
     
214. 0800110064030000 U            3 C
     
215. 020003007E030000 U            2 B
     
216. 02000B007F030000 U            4 D
     
217. 05001B0025040000 U            5
     
218.                  U            4
     
219. 
     
220. 6 rows selected.
     
221. 
     
222. SQL> select  versions_xid, versions_operation ,versions_startscn , a, b from t05311_a
     
223.   2  versions between scn minvalue and maxvalue ;
     
224. 
     
225. VERSIONS_XID         V VERSIONS_STARTSCN              A B
     
226. ---------------- - ----------------- ---------- --------------------
     
227. 03001C0080030000 I             1126744              1 A
     
228. 0800110064030000 U             1128449              3 C
     
229. 020003007E030000 U             1127241              2 B
     
230. 02000B007F030000 U             1128486              4 D
     
231. 05001B0025040000 U             1128666              5
     
232.                  U             1128543              4
     
233. 
     
234. 6 rows selected.
     
235. 
     
236. SQL>
     
237. SQL> select * from t05311_a
     
238.   2  as of timestamp to_timestamp('2017-08-22:21:11:55','YYYY-MM-DD:HH24:MI:SS');
     
239. 
     
240.          A B
     
241. ---------- --------------------
     
242.          4 D
     
243. 
     
244. SQL> alter table t05311_a enable row movement ;
     
245. 
     
246. Table altered.
     
247. 
     
248. SQL> flashback table to timestamp  to_timestamp('2017-08-22:21:11:55','YYYY-MM-DD:HH24:MI:SS');
     
249. flashback table to timestamp  to_timestamp('2017-08-22:21:11:55','YYYY-MM-DD:HH24:MI:SS')
     
250.                 *
     
251. ERROR at line 1:
     
252. ORA-00903: invalid table name
     
253. 
     
254. 
     
255. SQL> flashback table   t05311_a   to timestamp  to_timestamp('2017-08-22:21:11:55','YYYY-MM-DD:HH24:MI:SS');
     
256. flashback table   t05311_a   to timestamp  to_timestamp('2017-08-22:21:11:55','YYYY-MM-DD:HH24:MI:SS')
     
257.                   *
     
258. ERROR at line 1:
     
259. ORA-01466: unable to read data - table definition has changed
     
260. 
     
261. 
     
262. SQL>
     

复制代码

PL/SQL：

1. select  * from dba_flashback_archive;
   
2. 
   
3. select  * from dba_flashback_archive_ts;
   
4. 
   
5. select * from dba_flashback_archive_tables;
   
6. 
   
7. select  * from dba_tab_privs tp where tp.grantee='HR';
   
8. 
   
9. grant  flashback archive on fba1 to hr;
   
10. 
    
11. select  * from dba_tab_privs tp where tp.grantee='HR';
    
12. 
    
13. create flashback archive  default fba2  tablespace users
    
14. quota 20M  retention 1 year;
    
15. 
    
16. select  * from dba_flashback_archive;
    
17. 
    
18. grant flashback archive on fba2 to hr;
    
19. 
    
20. select  * from dba_flashback_archive_ts;
    
21. -------------------------
    
22. 
    
23. 
    
24. select * from dba_flashback_archive_tables;
    
25. 
    
26. alter flashback archive fba1 set default;
    
27. 
    
28. select  * from dba_flashback_archive;
    
29. ------------------
    
30. select  * from dba_flashback_archive_ts;
    
31. 
    
32. alter flashback archive fba2 add tablespace example quota 30M ;
    
33. 
    
34. alter flashback archive fba2 modify  tablespace users  quota 40M;
    
35. 
    
36. ----------
    
37. alter flashback archive fba2 modify retention 5 year;
    
38. 
    
39.   select  * from dba_flashback_archive;

复制代码

1. alter flashback archive fba2 purge before timestamp
   
2. (systimestamp- numtodsinterval('1','second')  );
   
3. 
   
4. select  * from dba_flashback_archive_tables;
   
5. 
   
6. select  * from hr.SYS_FBA_HIST_74619;
   
7. 
   
8. alter table hr.t05311_a no flashback archive;
   

复制代码

SQLPLUS：

1. SQL> show user
   
2. USER is "HR"
   
3. SQL> create table part1 (  a  number , b varchar2(20))  
   
4.   2  partition by range(a )
   
5.   3  ( partition p1 values less than(100),
   
6.   4    partition p2 values less than(maxvalue)) ;
   
7. 
   
8. Table created.
   
9. 
   
10. SQL> insert into part1 values (100, 'X' ) ;
    
11. 
    
12. 1 row created.
    
13. 
    
14. SQL> insert into part1 values (1000, 'X' ) ;
    
15. 
    
16. 1 row created.
    
17. 
    
18. SQL> commit;
    
19. 
    
20. Commit complete.
    
21. 
    
22. SQL> select  * from part1 partition ( p2 ) ;
    
23. 
    
24.          A B
    
25. ---------- --------------------
    
26.        100 X
    
27.       1000 X
    
28. 
    
29. SQL> alter table part1 flashback archive fba2  ;
    
30. 
    
31. Table altered.
    
32. 
    
33. SQL> select to_char(sysdate,'YYYY-MM-DD:HH24:MI:SS')  from dual;
    
34. 
    
35. TO_CHAR(SYSDATE,'YY
    
36. -------------------
    
37. 2017-08-22:21:35:30
    
38. 
    
39. SQL>
    
40. SQL> update part1 set a=200, b='Y' where a=100;
    
41. 
    
42. 1 row updated.
    
43. 
    
44. SQL> commit;
    
45. 
    
46. Commit complete.
    
47. 
    
48. SQL> select  * from SYS_FBA_HIST_74629;
    
49. select        * from SYS_FBA_HIST_74629
    
50.                *
    
51. ERROR at line 1:
    
52. ORA-00942: table or view does not exist
    
53. 
    
54. 
    
55. SQL> show user
    
56. USER is "HR"
    
57. SQL> select  * from SYS_FBA_HIST_74629;
    
58. 
    
59. RID
    
60. --------------------------------------------------------------------------------
    
61.   STARTSCN     ENDSCN XID               O          A B
    
62. ---------- ---------- ---------------- - ---------- --------------------
    
63. AAASOHAAEAAAAK+AAA
    
64.    1130315    1130446 0500110027040000 I        100 X
    
65. 
    
66. 
    
67. SQL> alter table part1 split partition p2 at ( 500)  into (partition p21 , partition p22 )  ;
    
68. alter table part1 split partition p2 at ( 500)        into (partition p21 , partition p22 )
    
69. *
    
70. ERROR at line 1:
    
71. ORA-55610: Invalid DDL statement on history-tracked table
    
72. 
    
73. 
    
74. SQL> select  * from SYS_FBA_HIST_74629;
    
75. 
    
76. RID
    
77. --------------------------------------------------------------------------------
    
78.   STARTSCN     ENDSCN XID               O          A B
    
79. ---------- ---------- ---------------- - ---------- --------------------
    
80. AAASOHAAEAAAAK+AAA
    
81.    1130315    1130446 0500110027040000 I        100 X
    
82. 
    
83. 
    
84. SQL> update SYS_FBA_HIST_74629 set a=101 where a=100 ;
    
85. 
    
86. 1 row updated.
    
87. 
    
88. SQL> commit;
    
89. 
    
90. Commit complete.
    
91. 
    
92. SQL> alter table part1 split partition p2 at ( 500)  into (partition p21 , partition p22 )  ;
    
93. 
    
94. Table altered.
    
95. 
    
96. SQL>  select  * from SYS_FBA_HIST_74629;
    
97. 
    
98. RID
    
99. --------------------------------------------------------------------------------
    
100.   STARTSCN     ENDSCN XID               O          A B
     
101. ---------- ---------- ---------------- - ---------- --------------------
     
102. AAASOHAAEAAAAK+AAA
     
103.    1130315    1130446 0500110027040000 I        101 X
     
104. 
     
105. 
     
106. SQL> select  * from part1 where a=100;
     
107. 
     
108. no rows selected
     
109. 
     
110. SQL> select  * from part1 ;
     
111. 
     
112.          A B
     
113. ---------- --------------------
     
114.        200 Y
     
115.       1000 X
     
116. 
     
117. SQL> select  * from part1 where a=200;
     
118. 
     
119.          A B
     
120. ---------- --------------------
     
121.        200 Y
     
122. 
     
123. SQL> select  * from part1 where a=200 as of scn 1130445;
     
124. select        * from part1 where a=200 as of scn 1130445
     
125.                                  *
     
126. ERROR at line 1:
     
127. ORA-00933: SQL command not properly ended
     
128. 
     
129. 
     
130. SQL> select  * from part1 as of scn 1130445 where  a=200;
     
131. 
     
132.          A B
     
133. ---------- --------------------
     
134.        200 Y
     
135. 
     
136. SQL> select  * from part1 as of scn 1130445 ;
     
137. 
     
138.          A B
     
139. ---------- --------------------
     
140.        101 X
     
141.       1000 X
     
142.        200 Y
     
143. 
     
144. SQL>
     

复制代码

PL/SQL：

1. drop flashback archive fba1;
   
2. 
   
3. select  * from dba_flashback_archive;
   
4. 
   
5. select  * from dba_flashback_archive_ts;
   
6. 
   
7. select  * from dba_flashback_archive_tables;
   
8. ----
   
9. 
   
10. select  * from dba_tab_partitions tp
    
11. where tp.table_owner='HR' and tp.table_name='PART1';
    
12. 
    
13. ----
    
14. 
    
15. begin
    
16.     dbms_flashback_archive.disassociate_fba(owner_name => 'HR',
    
17.     table_name => 'PART1') ;
    
18.     end;
    
19.    
    
20.      begin
    
21.     dbms_flashback_archive.reassociate_fba(owner_name => 'HR',
    
22.     table_name => 'PART1') ;
    
23.     end;
    
24.    

复制代码