I am trying to do an import using data pump, but I am struggling to come up with the right options. The export was taken as a schema export. I am trying to import just the tables, with no other database objects.
I am currently using
INCLUDE=TABLE TABLE_EXISTS_ACTION=REPLACE REMAP_SCHEMA= REMAP_TABLESPACE=
This is correctly importing the tables, but I am a little surprised to see that the import is also creating the constraints and triggers on the tables, or trying to at least. The triggers are failing because they include a schema name that does not exist in the database.
I thought that by using
INCLUDE=TABLE only the tables would be included. Apparently that is not the case. I am unable to use
EXCLUDE=TRIGGER as I am already using INCLUDE to limit the import to just tables.
Any ideas on how I could structure the import to only import tables?