How to include tempfile in creating crontrolfile from trace

Posted on 2006-05-27
Last Modified: 2008-01-09

My dictionary shows an tablespace entry TEMP01 but not the can add it in creating controlfile from trace
before opening the database. Is there any other option.

Thanks in advance.

Question by:bbasumatary
    LVL 16

    Expert Comment

    First create control file from trace and mount the database. Then using "alter database add tempfile ....." command add the tempfile for temporary tablespace. Open database.
    LVL 19

    Accepted Solution

    when you issue "alter database backup controlfile to trace", you will see steps to recreate control file, TEMP01 is only added  back after the database is reopen and you issue:

    alter tablespace temp add tempfile '...' reuse;

    >>how can add it in creating controlfile..
         NO, You can not ADD TEMP01 in "create controlfile ..." because control file doesn't contain any information about tempfile and only max information, datafiles and redo log file etc.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

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

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    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.

    794 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

    17 Experts available now in Live!

    Get 1:1 Help Now