You cannot COALESCE temporary TABLESPAC.

The valid options for temporary TABLESPACE are:
ADD TEMPFILE, TEMPFILE ONLINE, TEMPFILE OFFLINE


-----Original Message-----
From: Amrish Kothari (RBIN/EDM1)
[mailto:oracledba-ezmlmshield-x13356881.[Email address protected]
Sent: Wednesday, May 10, 2006 1:37 AM
To: LazyDBA Discussion
Subject: Error in coalescing table space

Hi,

I get this error while doing coalesce for temp tablespace:

[Email Address Removed] TABLESPACE TEMP COALESCE;
ALTER TABLESPACE TEMP COALESCE
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

Where can be the problem.


Regds,
Amkotz



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page