Sample Header Ad - 728x90

Oracle 19 recover table with remap and constraints issue

0 votes
1 answer
166 views
I have a Oracle 19 DB that I am testing table restores from RMAN backups. I am using this code.
recover table "HR".REGIONS OF PLUGGABLE DATABASE 'pdb'
                 until time "to_date('06/26/2024 08:00:00','mm/dd/yyyy hh24:mi:ss')"
                 auxiliary destination '+DATA'
                 REMAP TABLE 'HR'.'REGIONS':'REGIONS_NEW';
I get this error.
Performing import of tables...
   IMPDP> Master table "SYS"."TSPITR_IMP_fyrs_soEh" successfully loaded/unloaded
   IMPDP> Starting "SYS"."TSPITR_IMP_fyrs_soEh":
   IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
   IMPDP> ORA-39083: Object type TABLE:"HR"."REGIONS_NEW" failed to create with error:
ORA-02264: name already used by an existing constraint

Failing sql is:
CREATE TABLE "HR"."REGIONS_NEW" ("REGION_ID" NUMBER CONSTRAINT "REGION_ID_NN" NOT NULL ENABLE, "REGION_NAME" VARCHAR2(25 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS"
I am not sure why this is happening. According to the documentation the remap should not allow the indexes and constraints to be restored. How do I exclude them in my recover table statement > When you use the REMAP TABLE clause, named constraints and indexes cannot be imported.
Asked by cptkirkh (13 rep)
Jun 27, 2024, 06:36 PM
Last activity: Jul 9, 2025, 05:06 AM