Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • db_status.sql Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • sid_wise_sql.sql Oracle
  • Changing default shell Linux/Unix
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • scripts to take listener.log backup Linux/Unix
  • Jai Shree Ram Oracle
  • RAC with RHEL4 and 11g Oracle
  • How to sort list of files on basis of their sizes. Linux/Unix
  • PHP code to add WordPress posts in bulk programmatically PHP/MYSQL/Wordpress
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • Getting started with notebook Python/PySpark
  • When to rebuld B-tree index Oracle

Temporary Tablespace Information and restriction.

Posted on 27-Oct-2008 By Admin No Comments on Temporary Tablespace Information and restriction.

Temporary Tablespace

(1) The DEFAULT TEMPORARY TABLESPACE must be of TEMPORARY type.

(2) The DEFAULT TEMPORARY TABLESPACE cannot be converted to PERMANENT once it has been defined as the DEFAULT TEMPORARY TABLESPACE.

(3) Before dropping the DEFAULT TEMPORARY TABLESPACE, create another one.

(4) The DEFAULT TEMPORARY TABLESPACE cannot be taken OFFLINE:

(5) The temporary tablespace for users must be of TEMPORARY type in Oracle9i.(Please note, this is not a restriction in Oracle8 and Oracle8i.)

(6) If you drop the temporary tablespace of a user, and this temporary tablespace is not the DEFAULT TEMPORARY TABLESPACE for the database, the user’s temporary tablespace is not automatically switched to the DEFAULT TEMPORARY TABLESPACE.

Oracle, SQL scripts

Post navigation

Previous Post: Oracle Metalink useful notes
Next Post: default permission on ~/.ssh/authorized_keys2 or authorized_keys

Related Posts

  • Changing the Global Database Name Oracle
  • Implementing Listener Security Oracle
  • create database link syntax Oracle
  • How to Make Trace Files Created by Oracle Readable by All Users ? Oracle
  • V$transaction notes for finding XID composition. Oracle
  • Finding locked objects Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • USER_TABLES.Freelists Oracle
  • find_idle_cpu.sql Oracle
  • configUOCIOTTO.ora Oracle
  • Alter procedure auditing Oracle
  • Paste command syntax Linux/Unix
  • eplan.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme