| Navi |
Posted: Jun 28, 2007 06:33:46 AM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
I created permanent tablespace with no objects in it so i tried to switch from permanent tablespace to temporary tablespace and i got the following error...
SQL> alter tablespace student temporary;
alter tablespace student temporary
*
ERROR at line 1:
ORA-03218: invalid option for CREATE/ALTER TABLESPACE
Can someone tell me the problem with it?
Regards,
Naveen |
|
|
 Ratnaker |
| Posted: Jun 29, 2007 01:39:42 AM |  |
|
Total Post: 138
Joined: Apr, 2007
|
Hi Navi,
You cannot use the ALTER TABLESPACE statement, with the TEMPORARY keyword, to change a locally managed permanent tablespace into a locally managed temporary tablespace. You must use the CREATE TEMPORARY TABLESPACE statement to create a locally managed temporary tablespace.
K P Ratnaker
|
|
|
|
|
| Navi |
| Posted: Jun 29, 2007 03:05:37 AM | |
|
Total Post: 60
Joined: Jun, 2007
|
Hi Ratnaker,
Can you please tell me the steps to switch from premanent tablespace to temporary tablespace.
Regards,
Naveen
|
|
|
|
|
| Puspak |
| Posted: Jul 03, 2007 09:15:52 AM | |
|
Total Post: 3
Joined: Oct, 2006
|
step1:Cr8 a Tablespace
step2:alter database default temporary tablespace <tablespace _name>;
step3:drop the previous tablespace
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
