DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: TEMP TABLESPACE, NOT BACKUP?

  1. #1
    Join Date
    Jan 2002
    Posts
    58
    Is there any reason that you guys can see for a TEMPORARY tablespace to be backed up. I can not find anything that says that it has to be backed up. Let me know your thoughts.

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    If your temporary tablespace is dictionary managed (datafiles not tempfiles) you should back it up. Now you could offline drop the file(s) rather than recover if you didn't have a backup and then recreate the tablespace. I think it is easier to have a backup.
    In the case of tempfiles (locally managed temporary tablespace), they are used and destroyed by the starting up and shutting down of the database so there is no need to backup or recover.

    Regards,
    Rohit Nirkhe,Oracle Apps/DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Jun 2002
    Posts
    65
    Hi all
    How can i find out whether my tablespace is dictionary managed or locally managed it doesnt tell you in v$tablespace...does it....Thanks alot

  4. #4
    Join Date
    May 2000
    Location
    Huntsville, AL. USA
    Posts
    52
    Select tablespace_name, extent_management from dba_tablespaces;

    If it reads 'dictionary' then the data dictionary is storing the extent information, otherwise it will read 'local'.

  5. #5
    Join Date
    Jun 2002
    Posts
    65
    Thanks a lot grrickar....

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