SQL清除语句
来源:百度知道 编辑:UC知道 时间:2024/09/28 17:57:57
支持环境:
ASP/asp.net 1.1/php/
支持数据库:
ACCESS SQL2000 MySQL4.1
是phpMyAdmin 2.6.0
楼下几位说的我还是不懂哦,不好意思
CREATE SNAPSHOT [schema.]snapshot
[ [PCTFREE integer] [PCTUSED integer]
[INITRANS integer] [MAXTRANS integer]
[TABLESPACE tablespace]
[STORAGE storage_clause]
[ USING INDEX [ PCTFREE integer | TABLESPACE tablespace
| INITTRANS integer | MAXTRANS integer
| STORAGE storage_clause ] ...
| [CLUSTER cluster (column [, column]...)] ]
[ REFRESH [FAST | COMPLETE | FORCE] [START WITH date] [NEXT date]]
AS subquery
schema
is the schema to contain the snapshot. If you omit schema, Oracle
creates the snapshot in your sc