Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. All rights reserved by Burleson.
The following steps will demonstrate how to configure temporary tablespaces:. Skip to primary navigation Skip to main content Skip to primary sidebar Skip to footer navigation. You May Also Like. Oracle introduced temporary tablespaces in Oracle 7. Space will be allocated in a temporary tablespace for doing these types of operations.
Note that a temporary tablespace cannot contain permanent objects and therefore doesn't need to be backed up. A temporary tablespace contains schema objects only for the duration of a session.
Creating Temporary Tablespace in Oracle. Prior to Oracle 7. Oracle 7. Restrictions :. Tempfiles Temporary Datafiles. Unlike normal datafiles, temporary files are not fully allocated.
When you create a tempfiles, Oracle only writes to the header and last block of the file. This is why it is much quicker to create a tempfiles than to create a normal datafile. Tempfiles are not recorded in the database's control file. This implies that just recreate them whenever you restore the database, or after deleting them by accident. You can have different tempfile configurations between primary and standby databases in dataguard environment, or configure tempfiles to be local instead of shared in a RAC environment.
One cannot remove datafiles from a tablespace until you drop the entire tablespace. However, one can remove a tempfile from a database. Look at this example:. If you remove all tempfiles from a temporary tablespace, you may encounter an error:.
0コメント