tables parameter in export utility

[Stampy]

Hi

The setup here is Oracle 8.1.5/Solaris 2.7. I'm trying to export a db user that has around 400 tables. However, there are 5 very large (unpartitioned) tables that I don't need - containing auditing data. Is there any way of excluding only these tables from the export?

Thanks.

[jovery]

The only way you can do that is to create a table list with all the table names except those 5

[pando]

http://metalink.oracle.com/metalink/...&p_id=162914.1 for 8i

there is also another not so good way for 7 and 8 (or even 8i), you have to edit catexp.sql (making a backup), modify CREATE VIEW exu81tabs by adding and o$.name not in (blah blah your excluded tables here) once done restore your original catexp.sql

[adewri]

Another option,

1. move those big tables to a seperate tablespace,
2. make the tablespace offline
3. export full database.

Cheers

[jovery]

Or move those tables to another schema, and export by user.

[pando]

ein, how do you move tables to another user isnt that export import... CTAS drop

[adewri]

or take the database to a quack and sacrifice 101 developers...

this is the bestest method. MH will be happy

[adewri]

Originally posted by pando
ein, how do you move tables to another user isnt that export import... CTAS drop

or CTAD (Create table and drop)

[jovery]

Originally posted by pando
ein, how do you move tables to another user isnt that export import... CTAS drop

Yes but it would be a one off operation, once the tables had been moved it means he could perform a user export of the remaining tables with the minimum of fuss at any time.

[pando]

but thass extra time, probably to move 4 tables takes hours :-0

also how about the referential integrity....