<div>
You will need a command very similar to this:<br />
impdp username/password directory=LOGICAL_DIR_NAME<wbr /> dumpfile=schema_dump.dmp logfile=imp_package.log include=package:&quot;LIKE 'STTM_CUSTOMER_PKG%'&quot;<br />
<br />
Notes:<br />
1. The &quot;username&quot; should be the owner of the package you want to import<br />
2. The &quot;password&quot; must be the Oracle password for that user<br />
3. The LOGICAL_DIR_NAME must be the name of a logical directory in your target database. &nbsp;You may need to &quot;grant read, write on LOGICAL_DIR_NAME to [username];&quot; for the owner of the package, if that Oracle user doesn't have this permission now.<br />
4. The LOGICAL_DIR_NAME must be entered in upper-case, with no single quotes.<br />
5. You will have to copy your schema_dump.dmp to the physical directory that corresponds to your LOGICAL_DIR_NAME directory.
</div>


You will need a command very similar to this:
impdp username/password directory=LOGICAL_DIR_NAME dumpfile=schema_dump.dmp logfile=imp_package.log include=package:"LIKE 'STTM_CUSTOMER_PKG%'"

Notes:
1. The "username" should be the owner of the package you want to import
2. The "password" must be the Oracle password for that user
3. The LOGICAL_DIR_NAME must be the name of a logical directory in your target database.  You may need to "grant read, write on LOGICAL_DIR_NAME to [username];" for the owner of the package, if that Oracle user doesn't have this permission now.
4. The LOGICAL_DIR_NAME must be entered in upper-case, with no single quotes.
5. You will have to copy your schema_dump.dmp to the physical directory that corresponds to your LOGICAL_DIR_NAME directory.

Data Management

jtrifts

<div>
<div class="content wysiwyg-content">
How can I selectively import a package from a export dump(schema_dump.dmp) file using DBMS_DATAPUMP.<br />
for example I want to import a package called sttm_customer_pkg from a dump called schema_dump.dmp. please help me on this.
</div>
</div>


How can I selectively import a package from a export dump(schema_dump.dmp) file using DBMS_DATAPUMP.
for example I want to import a package called sttm_customer_pkg from a dump called schema_dump.dmp. please help me on this.

Selective package import from a available schema dump using DBMS_DATAPUMP

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.