在SQLPLUS里键入undrop.....时提示没有此命令？为什么？版本是： Release 10.1.0.2.0。谢谢！

flashbackup table xxx to before drop;

flashbackup这个命令也没有版本是：Database 10g Enterprise Edition Release 10.1.0.2.0.

select * from v$version;

看看什么具体信息

不会是Beta版本吧

QUOTE:

---

最初由 thinkless 发布
flashbackup这个命令也没有版本是：Database 10g Enterprise Edition Release 10.1.0.2.0.

---

sorry，是flashback table .... to before drop

使用flashback table命令，与beta版不同了.

PHP code:



$ sqlplus eygle/eygle





SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 27 17:25:52 2004





Copyright (c) 1982, 2004, Oracle.  All rights reserved.








Connected to:


Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production


With the Partitioning, OLAP and Data Mining options





SQL> select * from tab;





TNAME                          TABTYPE  CLUSTERID


------------------------------ ------- ----------


SP_TRANS                       TABLE


SP_TRANS_SUB                   TABLE


SP_RECEIVE                     TABLE


SP_RECEIVE_SUB                 TABLE


SP_ITEM                        TABLE


SP_CHK                         TABLE


SP_CHK_SUB                     TABLE


T1                             TABLE


T2                             TABLE


BIG_TABLE                      TABLE


TT                             TABLE





TNAME                          TABTYPE  CLUSTERID


------------------------------ ------- ----------


DMLSQL_LOG                     TABLE


BIG_BIG_TABLE                  TABLE





13 rows selected.





SQL> show recyclebin


SQL> drop table t1;





Table dropped.





SQL> show recyclebin


ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME


---------------- ------------------------------ ------------ -------------------


T1               BIN$2QoWJ/VNPV/gNAgAIMR+0Q==$0 TABLE        2004-04-27:17:26:19


SQL> select * from tab;





TNAME                          TABTYPE  CLUSTERID


------------------------------ ------- ----------


SP_TRANS                       TABLE


SP_TRANS_SUB                   TABLE


SP_RECEIVE                     TABLE


SP_RECEIVE_SUB                 TABLE


SP_ITEM                        TABLE


SP_CHK                         TABLE


SP_CHK_SUB                     TABLE


BIN$2QoWJ/VNPV/gNAgAIMR+0Q==$0 TABLE


T2                             TABLE


BIG_TABLE                      TABLE


TT                             TABLE





TNAME                          TABTYPE  CLUSTERID


------------------------------ ------- ----------


DMLSQL_LOG                     TABLE


BIG_BIG_TABLE                  TABLE





13 rows selected.





SQL>  FLASHBACK TABLE t1 TO BEFORE DROP;





Flashback complete.





SQL> desc t1


 Name                                      Null?    Type


 ----------------------------------------- -------- ----------------------------


 OWNER                                              VARCHAR2(30)


 OBJECT_NAME                                        VARCHAR2(30)


 SUBOBJECT_NAME                                     VARCHAR2(30)


 OBJECT_ID                                          NUMBER


 DATA_OBJECT_ID                                     NUMBER


 OBJECT_TYPE                                        VARCHAR2(19)


 CREATED                                            DATE


 LAST_DDL_TIME                                      DATE


 TIMESTAMP                                          VARCHAR2(19)


 STATUS                                             VARCHAR2(7)


 TEMPORARY                                          VARCHAR2(1)


 GENERATED                                          VARCHAR2(1)


 SECONDARY                                          VARCHAR2(1)





SQL> select * from tab;





TNAME                          TABTYPE  CLUSTERID


------------------------------ ------- ----------


SP_TRANS                       TABLE


SP_TRANS_SUB                   TABLE


SP_RECEIVE                     TABLE


SP_RECEIVE_SUB                 TABLE


SP_ITEM                        TABLE


SP_CHK                         TABLE


SP_CHK_SUB                     TABLE


T2                             TABLE


BIG_TABLE                      TABLE


TT                             TABLE


T1                             TABLE





TNAME                          TABTYPE  CLUSTERID


------------------------------ ------- ----------


DMLSQL_LOG                     TABLE


BIG_BIG_TABLE                  TABLE





13 rows selected.





SQL> drop table t1;





Table dropped.





SQL> drop table t2;





Table dropped.





SQL> drop table tt;





Table dropped.





SQL> show recyclebin                    


ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME


---------------- ------------------------------ ------------ -------------------


T1               BIN$2QoWJ/VOPV/gNAgAIMR+0Q==$0 TABLE        2004-04-27:17:28:13


T2               BIN$2QoWJ/VQPV/gNAgAIMR+0Q==$0 TABLE        2004-04-27:17:28:16


TT               BIN$2QoWJ/VYPV/gNAgAIMR+0Q==$0 TABLE        2004-04-27:17:28:21


SQL> purge table t1;





Table purged.





SQL> show recyclebin  


ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME


---------------- ------------------------------ ------------ -------------------


T2               BIN$2QoWJ/VQPV/gNAgAIMR+0Q==$0 TABLE        2004-04-27:17:28:16


TT               BIN$2QoWJ/VYPV/gNAgAIMR+0Q==$0 TABLE        2004-04-27:17:28:21


SQL> purge recyclebin;





Recyclebin purged.





SQL> show