Sample Header Ad - 728x90

Import Tables without Constraints from Schema Export

2 votes
2 answers
14753 views
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=CONSTRAINT or 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?
Asked by Patrick (698 rep)
Oct 28, 2020, 04:08 AM
Last activity: Oct 30, 2020, 06:58 AM