What is Minimum size for Temporary tablespaces or temp files.

Posted on 2006-05-17
Last Modified: 2013-12-11
I am getting an error message ORA-03214' when trying to create
a temporary table space. Is there a set minimum or is is based on database setup?
Question by:timjshields
    LVL 6

    Expert Comment

    For me the size of 2m works fines.  is there any reason why you need to create  temp ts of so small size...

    SQL> create temporary tablespace temp00 tempfile '/tmp/temp00.001' size 2m;
    This worked fine.


    Author Comment

    Before going on to the size again. Let me ask you this.
    If I already have a Tablespace called Temp created when I created the database
    would I need to create a new temporary tablespace for the users?
    LVL 6

    Accepted Solution

    not required.
    You can check if this is the default temporary tablespace for users by the following query

     select PROPERTY_NAME,PROPERTY_VALUE from database_properties where PROPERTY_NAME  like '%TEMP%';

    Author Comment

    It is thanks.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle 10g - Count Rows excluding 0's 4 47
    Cross Outer Join 4 42
    Create index on View 27 46
    Oracle PL/SQL syntax 4 30
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now