<div>
Hi marrowyung,<br><br>I think there's an easier way. &nbsp;:)<br><br>From sys, run this:<br><br>&nbsp; alter database <strong>backup</strong> <strong>controlfile</strong> <strong>to</strong> <strong>trace</strong>.<br><br>In the trace file will be two text scripts. &nbsp;They're nearly identical with the real difference being the naming of the new instance. &nbsp;You'll still need to create the instance and restore the data, but this will do most of the heavy lifting.<br><br>:)<br><br>
</div>


<div>
"SQL&gt; @?/rdbms/admin/catalog.sql &nbsp; &nbsp;<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SQL&gt; @?/rdbms/admin/catproc.sql &nbsp; &nbsp;<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SQL&gt; @?/rdbms/admin/utlrp.sql<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SQL&gt; @?/sqlplus/admin/pupbld.sql(run as system)"<br>This is to run each of the script from oracle, right? catproc.sql, utlrp.sql and pupbid.sql ?<br><br><blockquote><br>I think there's an easier way. &nbsp;:)</blockquote><br>but the above also works ?
</div>


<div>
but seems for impdp command we have to add CONTENT=METADATA_ONLY ? anything else ?
</div>


<div>
I've never built a system from the scripts you're using so I don't know if they're sufficient. &nbsp;I suspect that they are.<br><br>Wondering about the use of METADATA_ONLY. &nbsp;Are you trying to create and empty database?
</div>


Senior Database Architecture 

marrowyung

<div>
<blockquote>Are you trying to create and empty database? </blockquote><br>yeah I am creating a empt database.<br><br>
</div>


<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
right now we want to create a new Oracle instance A by copying the metadata from other Oracle instance B<br />
<br />
please let me know if the following steps are ok:<br />
<br />
<br />
# 1) &nbsp;Create a 300G new FS /ora/u40 for instance A <br />
<br />
# 2) &nbsp;export HUETL02 with metadata<br />
export ORACLE_SID=instance B<br />
expdp \&quot;/ as sysdba\&quot; full=y directory=&lt;instance B&gt; &nbsp;dumpfile=&quot;&lt;instance B&gt;_20200509.dmp&quot; content=metadata_only logfile=exp_&lt;instance B&gt;.log<br />
# 3) Create new instance instance A <br />
3.1 create pfile<br />
3.2 create database<br />
3.3 execute script<br />
SQL&gt; @?/rdbms/admin/catalog.sql<wbr /> &nbsp; &nbsp;<br />
SQL&gt; @?/rdbms/admin/catproc.sql<wbr /> &nbsp; &nbsp;<br />
SQL&gt; @?/rdbms/admin/utlrp.sql <br />
SQL&gt; @?/sqlplus/admin/pupbld.sq<wbr />l(run as system)<br />
# 4) Create user tablespace for instance A <br />
# 5) import instance A <br />
<br />
export ORACLE_SID=instance A <br />
impdp \&quot;/ as sysdba\&quot; full=y directory=&lt;instance A&gt; dumpfile=&quot;HUETL02_20200509<wbr />.dmp&quot; full=y logfile=imp_&lt;instance A &gt;.log<br />
<br />
is the steps ok?
</div>
</div>


hi,

right now we want to create a new Oracle instance A by copying the metadata from other Oracle instance B

please let me know if the following steps are ok:


# 1)  Create a 300G new FS /ora/u40 for instance A 

# 2)  export HUETL02 with metadata
export ORACLE_SID=instance B
expdp \"/ as sysdba\" full=y directory=<instance B>  dumpfile="<instance B>_20200509.dmp" content=metadata_only logfile=exp_<instance B>.log
# 3) Create new instance instance A 
3.1 create pfile
3.2 create database
3.3 execute script
SQL> @?/rdbms/admin/catalog.sql    
SQL> @?/rdbms/admin/catproc.sql    
SQL> @?/rdbms/admin/utlrp.sql 
SQL> @?/sqlplus/admin/pupbld.sql(run as system)
# 4) Create user tablespace for instance A 
# 5) import instance A 

export ORACLE_SID=instance A 
impdp \"/ as sysdba\" full=y directory=<instance A> dumpfile="HUETL02_20200509.dmp" full=y logfile=imp_<instance A >.log

is the steps ok?

create new oracle instance by copying medatat from other oracle instance

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.