09:24:55 SQL> help create snapshot CREATE SNAPSHOT
--------------- Use this command to create a snapshot. A snapshot is a table that
contains the results of a query of one or more tables or views,
often located on a remote database. CREATE SNAPSHOT [schema.]snapshot
{ { PCTFREE integer
| PCTUSED integer
| INITRANS integer
| MAXTRANS integer
| TABLESPACE tablespace
| STORAGE storage_clause}
| CLUSTER cluster (column [, column] ...) } ...
[ USING {INDEX [ PCTFREE integer
| PCTUSED integer
| INITRANS integer
| MAXTRANS integer ]
| [DEFAULT] [MASTER | LOCAL] ROLLBACK SEGMENT
[rollback_segment] } ]
[ REFRESH [FAST | COMPLETE | FORCE]
[ START WITH date]
[ NEXT date]
[ WITH {PRIMARY KEY | ROWID}] ]
[ FOR UPDATE] AS subquery For detailed information on this command, see the Oracle8 Server SQL
Reference.
CREATE SNAPSHOT LOG
------------------- Use this command to create a snapshot log. A snapshot log is a table
associated with the master table of a snapshot. Oracle stores
changes to the master table's data in the snapshot log and then
uses the snapshot log to refresh the master table's snapshots. CREATE SNAPSHOT LOG ON [schema.]table
[ WITH { [PRIMARY KEY]
[,ROWID]
[,(filter column)
| ,(filter column) ...] }
[ PCTFREE integer
| PCTUSED integer
| INITRANS integer
| MAXTRANS integer
| TABLESPACE tablespace
| STORAGE storage_clause] ... For detailed information on this command, see the Oracle8 Server SQL
Reference.
--------------- Use this command to create a snapshot. A snapshot is a table that
contains the results of a query of one or more tables or views,
often located on a remote database. CREATE SNAPSHOT [schema.]snapshot
{ { PCTFREE integer
| PCTUSED integer
| INITRANS integer
| MAXTRANS integer
| TABLESPACE tablespace
| STORAGE storage_clause}
| CLUSTER cluster (column [, column] ...) } ...
[ USING {INDEX [ PCTFREE integer
| PCTUSED integer
| INITRANS integer
| MAXTRANS integer ]
| [DEFAULT] [MASTER | LOCAL] ROLLBACK SEGMENT
[rollback_segment] } ]
[ REFRESH [FAST | COMPLETE | FORCE]
[ START WITH date]
[ NEXT date]
[ WITH {PRIMARY KEY | ROWID}] ]
[ FOR UPDATE] AS subquery For detailed information on this command, see the Oracle8 Server SQL
Reference.
CREATE SNAPSHOT LOG
------------------- Use this command to create a snapshot log. A snapshot log is a table
associated with the master table of a snapshot. Oracle stores
changes to the master table's data in the snapshot log and then
uses the snapshot log to refresh the master table's snapshots. CREATE SNAPSHOT LOG ON [schema.]table
[ WITH { [PRIMARY KEY]
[,ROWID]
[,(filter column)
| ,(filter column) ...] }
[ PCTFREE integer
| PCTUSED integer
| INITRANS integer
| MAXTRANS integer
| TABLESPACE tablespace
| STORAGE storage_clause] ... For detailed information on this command, see the Oracle8 Server SQL
Reference.
,能否从创建连接开始讲??