create tablespace temp
datafile <--- change to tempfile
joe
tony ynot wrote:
An Oracle consultant made the following comment about
our 11i db:
"You need to drop the current temp Tablespace and
recreate it using temp files,
uniform 1MB extents."
We have a TEMP tablespace created by "create
tab
Also the "temporary" key word is right after the create
instead of at the end of the statement.
create temporary tablespace temp tempfile ''
extent management local uniform size nnn.
-Original Message-
Sent: Friday, December 20, 2002 9:14 PM
To: Multiple recipients of list ORACLE-