创建用户的标准语法(oracle9i)
CREATE USER user IDENTIFIED
{ BY password | EXTERNALLY | GLOBALLY AS ' external_name ' }
[ { DEFAULT TABLESPACE tablespace #指定该用户的默认表空间
| TEMPORARY TABLESPACE tablespace #指定该用户使用的临时表空间
| QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace
[ QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace]...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK }
}
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace
[ QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace]...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK }
]...
]
;
创建表空间的标准语句(oracle9i)
CREATE [ UNDO ] TABLESPACE tablespace
[ DATAFILE datafile_tempfile_spec [, datafile_tempfile_spec ] ... ]
[ { MINIMUM EXTENT integer [ K | M ]
| BLOCKSIZE integer [ K ]
| logging_clause
| FORCE LOGGING
| DEFAULT [ data_segment_compression ] storage_clause
| { ONLINE | OFFLINE }
| { PERMANENT | TEMPORARY }
| extent_management_clause
| segment_management_clause
}
[ MINIMUM EXTENT integer [ K | M ]
| BLOCKSIZE integer [ K ]
| logging_clause
| FORCE LOGGING
| DEFAULT [ data_segment_compression ] storage_clause
| { ONLINE | OFFLINE }
| { PERMANENT | TEMPORARY }
| extent_management_clause
| segment_management_clause
]...
]
;