permanent to temporary

[nunnasujatha]

Hi all,
i ve tried to convert a permanent tablespace to temporary.

for this i 've used

alter tablespace test_per_ts temporary;

ERROR:invalid option for create/alter tablespace.

Note:There are no objects in my permanent table space test_per_ts.

[pragatiswain]

Hi all,
i ve tried to convert a permanent tablespace to temporary.

for this i 've used

alter tablespace test_per_ts temporary;

ERROR:invalid option for create/alter tablespace.

Note:There are no objects in my permanent table space test_per_ts.

What is the ORA Error Code?
Try this:
alter tablespace test_per_ts OFFLINE IMMEDIATE;
alter tablespace test_per_ts temporary;

[nunnasujatha]

it didn't work too.

SQL> alter tablespace test_per_ts temporary;
alter tablespace suj_second_tab temporary
*
ERROR at line 1:
ORA-03218: invalid option for CREATE/ALTER TABLESPACE

[pragatiswain]

it didn't work too.

SQL> alter tablespace test_per_ts temporary;
alter tablespace suj_second_tab temporary
*
ERROR at line 1:
ORA-03218: invalid option for CREATE/ALTER TABLESPACE

Check this out.

SQL> grant unlimited tablespace to <MY_USER>;
--- Then Check Priviledges, should show "UNLIMITED TABLESPACE"
SQL> select * from session_privs;

Then try doing what you wanted to do.

[debasisdas]

please use this

[CODE=oracle]alter tablespace test_per_ts offline temporary;[/CODE]