Generating the table list would be the way I'd go, but one alternative
way would be to temporarily modify export views to achieve this:
- rename EXU9TABU view in sys schema to EXU9TABU_BAK (or EXU81TABU or
EXU10TABU view, depending on which version of exp you're gonna use).
- create view exu9tabu as select * from sys.exu9tabu_bak where name
not in ('T1', 'T2');
- grant select on exu9tabu to public;
- run your schema export (these 2 tables will be excluded thanks to
new view)
- drop view sys.exu9tabu
- rename sys.exu9tabu_bak back to exu9tabu
Or if on 10g - expdp has the exclude keyword...
Tanel.
Received on Tue Dec 28 2004 - 08:02:37 CST