Temporary Tbalespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Temporary Tbalespaces

  1. #1
    Join Date
    Feb 2002
    Posts
    18
    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???

  2. #2
    Join Date
    Feb 2001
    Posts
    290
    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
  •  


Click Here to Expand Forum to Full Width