<div>
First create control file from trace and mount the database. Then using &quot;alter database add tempfile .....&quot; command add the tempfile for temporary tablespace. Open database.
</div>


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.

<div>
<div class="content wysiwyg-content">
Gurus,<br />
<br />
My dictionary shows an tablespace entry TEMP01 but not the controlfile...how can add it in creating controlfile from trace <br />
before opening the database. Is there any other option.<br />
<br />
Thanks in advance.<br />
<br />
Regards,<br />
\\bbasumatary
</div>
</div>


Gurus,

My dictionary shows an tablespace entry TEMP01 but not the controlfile...how can add it in creating controlfile from trace 
before opening the database. Is there any other option.

Thanks in advance.

Regards,
\\bbasumatary

How to include tempfile in creating crontrolfile from trace

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.