Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Reading parameter file and printing Linux/Unix
  • To Find Orphan OS processes. Linux/Unix
  • Transfer SQL Profiles from One database to other database. Oracle
  • Renaming the column name Oracle
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
  • CPU Core related projections AWS
  • Oracle 11g Training on 29JAN1010 Oracle
  • Another export with Query Oracle
  • Oracle Data Direct to TAPE Oracle
  • lck.sql Oracle
  • Find all users who have DML privileges Oracle
  • SQL_PROFILE – I explaination Oracle
  • process id based files and processes Linux/Unix
  • scp with ssh2 Linux/Unix
  • Oracle Recommended Patches — Oracle Database ID 756671.1 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

  • To see how much time or progress of long transaction Oracle
  • How to choose Driver table in SQL statement Oracle
  • create trigger syntax Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
  • Difference between SYNC and AFFIRM 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • RAC with RHEL4 and 11g Oracle
  • Korn Shell Arithmatic Linux/Unix
  • How to calculate PROCESSES parameter Oracle
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • S3 Basic info AWS
  • Jai Shree Ram Oracle
  • Wait time tuning research Oracle
  • This is from Temi Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme