<div>
thanks for the quick response.<br />
I need to only one schema. the problem is that i want dont want to import one object which is present in the source schema.
</div>


<div>
how can i do that?<br />
we can take the table level backup but importing one table from one particuar schema wil be time consuming.<br />
there is no parameter which we can use to exclude one table.<br />
if there will be 20 objects in the source schema then i have imp 19 schema one after the other. 
</div>


<div>
create dummy structure for which table.
</div>


<div>
can we do it while taking export?<br />

</div>


<div>
I jsut want to skip one table.<br />
i.e that table should not get imported in the target schema.
</div>


<div>
create dummy for the table you want to exclude<br />
<br />
that way the import is &quot;blocked&quot; from creating it again.<br />
<br />
using ignore='Y' will tell the import to ignore the error and continue anyway.<br />
can you please explain me this in &nbsp;more detail?
</div>


<div>
for 19 tables i have to use par file.
</div>


<div>
how to create the dummy structures for that particular table.
</div>


<div>
create table your_table(dummy_column &nbsp;number);
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I need to take the export of one schema and import to other schema in other database.<br />
but i want to exclude one of the table from source schema.<br />
suppose i have 10 object in schema and i dont want one schema(suppose emp) not to be imported in destination &nbsp;schema in the other database.<br />
could you please help me on this?
</div>
</div>


Hi Experts,
I need to take the export of one schema and import to other schema in other database.
but i want to exclude one of the table from source schema.
suppose i have 10 object in schema and i dont want one schema(suppose emp) not to be imported in destination  schema in the other database.
could you please help me on this?

how to exclude one of the table during imp/exp?

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.

Unix OS

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

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.