Oracle tablespace, user

Create a user's standard syntax (Oracle9i)

Create user identified
{By password | externally | globally as 'external _ name '}
[{Default tablespace # specify the user's default tablespace
| Temporary tablespace # specify the temporary tablespace used by the user
| Quota {INTEGER [k | M] | unlimited} on tablespace
[Quota {INTEGER [k | M] | unlimited} on tablespace]...
| Profile Profile
| Password expire
| Account {lock | unlock}
}
[Default tablespace
| Temporary tablespace
| Quota {INTEGER [k | M] | unlimited} on tablespace
[Quota {INTEGER [k | M] | unlimited} on tablespace]...
| Profile Profile
| Password expire
| Account {lock | unlock}
]...
]
;

Standard statement for creating a tablespace (Oracle9i)

Create [undo] 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
]...
]
;