Link to home
Start Free TrialLog in
Avatar of daniesh
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?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniesh
daniesh

ASKER

thanks for the quick response.
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniesh

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.
Avatar of daniesh

ASKER

create dummy structure for which table.
Avatar of daniesh

ASKER

can we do it while taking export?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniesh

ASKER

I jsut want to skip one table.
i.e that table should not get imported in the target schema.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniesh

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?
Avatar of daniesh

ASKER

for 19 tables i have to use par file.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniesh

ASKER

how to create the dummy structures for that particular table.
create table your_table(dummy_column  number);
Avatar of daniesh

ASKER

ok ..
thanks.
glad we could help