ITPub博客

首页 > Linux操作系统 > Linux操作系统 > flashback闪回删除

flashback闪回删除

原创 Linux操作系统 作者:gaiguoxiang 时间:2012-05-20 13:41:07 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-06-22

  • 博文量
    41
  • 访问量
    106627