Can I migrate tables without the triggers?

I'd like to migrate all tables, data, and indexes for a given Oracle schema (approx 2000 tables).

I do want to migrate the triggers. I am looking for a way to do this without visiting each table and deselecting its triggers.

Upvotes: 6

Answers (2)

Reputation: 906

The simple answer would be to migrate everything and build a script using something like;

select 'drop trigger ' || trigger_name || ';' from all_triggers where owner = 'MYSCHEMA';

Upvotes: 1

Reputation: 80

If your database is 11g or above, you can use the expdp utility with include=triggers qualifier.

Upvotes: 0