-
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???
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|