Re: impdp from 12c to 19c

Posted by Roshan on Dec 03, 2022; 1:52pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/impdp-from-12c-to-19c-tp11317p11324.html

I see these indexes are primary key indexes. As per doc below, this seems to be a normal behaviour. Please confirm.

ID: 951994.1

Will these missing indexes affect performance?

source.txt
target.txt

source ddl:

  CREATE TABLE "****"."****"
   (    "ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 99
99999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
  NOKEEP  NOSCALE  NOT NULL ENABLE,
        "LOOKUP_TYPE" VARCHAR2(240),
        "DESCRIPTION" VARCHAR2(2000),
        "START_DATE" DATE,
        "END_DATE" DATE,
        "ACCESS_LEVEL" VARCHAR2(240),
        "CODE" VARCHAR2(240),
        "CODE_DESC" VARCHAR2(2000),
        "TAG" VARCHAR2(240),

        "CREATED_BY" VARCHAR2(240),
        "CREATED_ON" DATE DEFAULT sysdate,
        "UPDATED_ON" DATE DEFAULT sysdate,
        "UPDATED_BY" VARCHAR2(240),
        "ACTIVE" VARCHAR2(1),
         CONSTRAINT "LOOKUP_ID_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  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 "BPMDATAPROD_MU"  ENABLE
   ) 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 "BPMDATAPROD_MU"