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
Last activity: Oct 30, 2020, 06:58 AM