flashback闪回删除

SQL> show parameter bin

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
recyclebin string on
SQL>
SQL>
SQL> conn ggx/ggx
Connected.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> create tables ggx (name varchar(20),age number);
create tables ggx (name varchar(20),age number)
*
ERROR at line 1:
ORA-00901: invalid CREATE command

SQL>
SQL>
SQL> create tables ggx(name varchar(20),age number);
create tables ggx(name varchar(20),age number)
*
ERROR at line 1:
ORA-00901: invalid CREATE command

SQL> c/tables/table
1* create table ggx(name varchar(20),age number)
SQL> /

Table created.

SQL>
SQL>
SQL>
SQL> insert into ggx values('ggx',26);

1 row created.

SQL> insert into ggx select * from ggx;

1 row created.

SQL> /

2 rows created.

SQL> /

4 rows created.

SQL> /

8 rows created.

SQL> /

16 rows created.

SQL> /

32 rows created.

SQL> commit;

Commit complete.

SQL>
SQL>
SQL> select count(*) from ggx;
select count(*) formrom ggx
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> select count(*) from ggx;

COUNT(*)
----------
64

SQL>
SQL>
SQL>
SQL> drop table ggx;

Table dropped.

SQL>
SQL>
SQL> selct
SP2-0042: unknown command "selct" - rest of line ignored.
SQL>
SQL>
SQL>
SQL> select object_name,original_name,type from user_recyclebin;

OBJECT_NAME ORIGINAL_NAME
------------------------------ --------------------------------
TYPE
-------------------------
BIN$uPhMarbyAC7gQwoBCNcALg==$0 GGX
TABLE

SQL> select count(*) from "BIN$uPhMarbyAC7gQwoBCNcALg==$0";

COUNT(*)
----------
64

SQL>
SQL>
SQL> delete from "BIN$uPhMarbyAC7gQwoBCNcALg==$0";
delete from "BIN$uPhMarbyAC7gQwoBCNcALg==$0"
*
ERROR at line 1:
ORA-38301: can not perform. DDL/DML over objects in Recycle Bin

SQL>
SQL>
SQL>
SQL>
SQL>
SQL> flashback table ggx to beforedrop;
flashback table ggx to beforedrop
*
ERROR at line 1:
ORA-00905: missing keyword

SQL> flashback table ggx to before drop;

Flashback complete.

SQL> select object_name,original_name,type from user_recyclebin;

no rows selected

SQL> select count(*) from ggx;

COUNT(*)
----------
64

SQL>
SQL> drop table ggx purge;

Table dropped.

SQL> select object_name,original_name,type from user_recyclebin;

no rows selected

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25517773/viewspace-730312/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25517773/viewspace-730312/