| Change permanent tablespace to temporary [message #58996] |
Mon, 20 October 2003 15:26  |
Joan
Messages: 36
Registered: February 2002
|
Member |
|
|
I have tablespace a1 that is of permanet type. Can I change it to temporaray. The goal is to alter database and define it at default temporary tablespace.
I am just trying to avoid recreating the existing tablespace.
|
|
|
|
| Re: Change permanent tablespace to temporary [message #58998 is a reply to message #58996] |
Mon, 20 October 2003 20:59  |
cmn
Messages: 19
Registered: March 2002
|
Junior Member |
|
|
you can issue "alter tablespace tbs_name temporary" to change permanent tbs to temporary tbs.But you must ensure that the objects on origial tbs you need't used.
Once you change tbs to temporary,the objects on that tbs can't be used any longer.You can export the data and import those data to another tbs if you will use those objects.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
