-
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.
-
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
-
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
-
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'.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|