Temporary Tbalespaces

[Manpreet]

Just wanted to ask if anyone had any issues after coverting temporary tablespace having PEMANENT contents to temporary tablespace haviing TEMPORARY contents.I know temp tablespace should be created using TEMPORARY content option as this increases performance.Just wanted to know if there any issues as well???

[mrvajrala]

You have to make sure that , there are no permanent objects in the TEMP tablespace to the TEMP tablespace with temporary segments. If not Oracle will not allow you to made it as temporary tablespace.

So all you have to do is , find out if there is any permanent object in the tablespace , if not you can convert it using

ALTER TABLESPACE TEMP TEMPORARY;

hope this will help you,
Madhu