6

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.

Peter Mortensen
  • 30,738
  • 21
  • 105
  • 131
ctjrb
  • 61
  • 3

2 Answers2

1

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';
Peter Mortensen
  • 30,738
  • 21
  • 105
  • 131
Paul Stearns
  • 856
  • 9
  • 30
0

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

Peter Mortensen
  • 30,738
  • 21
  • 105
  • 131
Sami
  • 45
  • 7