<div>
Its been a long time since I did a FULL import. Â Are you cure a FULL won't create users?<br />
<br />
Anyway, use the SHOW=Y and INDEXFILE parameters. Â The indexfile should show all the commands (they should be commented out).<br />
<br />
If that doesn't work, use logfile with show=Y. Â It will require more editing to ger executable.
</div>


<div>
i will try that, imp will not create user for a full import for sure...thanks..
</div>


<div>
<div class="content wysiwyg-content">
i created a fresh new db and have to do a full import from a dump file . Export was done using exp utility.<br />
<br />
Inorder to do a full import, i need to firsh create user schemas,tablespaces of export dump file , <br />
<br />
how can i extract the user schemas and created them before before importing...thanks ...<br />
<br />
i know about imdp, but this is using imp utility.
</div>
</div>


i created a fresh new db and have to do a full import from a dump file . Export was done using exp utility.

Inorder to do a full import, i need to firsh create user schemas,tablespaces of export dump file , 

how can i extract the user schemas and created them before before importing...thanks ...

i know about imdp, but this is using imp utility.

Its been a long time since I did a FULL import. Â Are you cure a FULL won&#39;t create users?

Anyway, use the SHOW=Y and INDEXFILE parameters. Â The indexfile should show all the commands (they should be commented out).

If that doesn&#39;t work, use logfile with show=Y. Â It will require more editing to ger executable.

i will try that, imp will not create user for a full import for sure...thanks..

imp utility (full import)

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.