Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Monitor Long Running Job Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • Jai Shree Ram Oracle
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
  • plan10g.sql good1 Oracle
  • UNderstand and eliminate Latch contention. Oracle
  • Database logon trigger issue Oracle
  • Implementing Listener Security Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • grep multuple patterns Linux/Unix
  • Sequence Resetting Oracle
  • 10g oem configuration Oracle
  • ext#.sql Oracle
  • Giving Grant on v$DATABASE Oracle
  • Remove DOS CR/LFs (^M) Linux/Unix

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

  • myfile Oracle
  • Giving Grant on v$DATABASE Oracle
  • Vivek Tuning for Row Locks. Oracle
  • Find average Row Length and other table size calculation. metalink notes Oracle
  • Find sort details from Db find_sort.sql Oracle
  • V$CONTROLFILE_RECORD_SECTION reference notes. 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
  • Kernel Parameters for Solaris Linux/Unix
  • Default User Profile Oracle
  • oracle 10g on linux Linux/Unix
  • Important Script Method for tuning Oracle
  • Rename Oracle Instance Name Oracle
  • Create type and Grant on it. Oracle
  • Export Import with QUERY Oracle
  • Drop all SPM baselines for SQL handle Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme