tanel.poder_at_gmail.com wrote:
> 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:
>
> 1) rename EXU9TABU view in sys schema to EXU9TABU_BAK (or EXU81TABU or
> EXU10TABU view, depending on which version of exp you're gonna use).
> 2) create view exu9tabu as select * from sys.exu9tabu_bak where name
> not in ('T1', 'T2');
> 3) grant select on exu9tabu to public;
> 4) run your schema export (these 2 tables will be excluded thanks to
> new view)
> 5) drop view sys.exu9tabu
> 6) rename sys.exu9tabu_bak back to exu9tabu
> Or if on 10g - expdp has the exclude keyword...
>
> Tanel.
>
Norty, norty! Step 0 should of course, be:
make a full backup of your entire database
--
Regards,
Frank van Bortel
Received on Wed Dec 29 2004 - 06:02:55 CST
