daniesh
asked on
how to exclude one of the table during imp/exp?
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how can i do that?
we can take the table level backup but importing one table from one particuar schema wil be time consuming.
there is no parameter which we can use to exclude one table.
if there will be 20 objects in the source schema then i have imp 19 schema one after the other.
we can take the table level backup but importing one table from one particuar schema wil be time consuming.
there is no parameter which we can use to exclude one table.
if there will be 20 objects in the source schema then i have imp 19 schema one after the other.
ASKER
create dummy structure for which table.
ASKER
can we do it while taking export?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I jsut want to skip one table.
i.e that table should not get imported in the target schema.
i.e that table should not get imported in the target schema.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
create dummy for the table you want to exclude
that way the import is "blocked" from creating it again.
using ignore='Y' will tell the import to ignore the error and continue anyway.
can you please explain me this in more detail?
that way the import is "blocked" from creating it again.
using ignore='Y' will tell the import to ignore the error and continue anyway.
can you please explain me this in more detail?
ASKER
for 19 tables i have to use par file.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how to create the dummy structures for that particular table.
create table your_table(dummy_column number);
ASKER
ok ..
thanks.
thanks.
glad we could help
ASKER
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.