Create New Indexes

  1. Log in to Oracle Database 19c as the SYS user at the container database (CDB) and pluggable database (PDB).
  2. Search for the following indexes:
    • i_type3 on type$(roottoid)
    • i_type4 on type$(supertoid)
  3. If you cannot locate the indexes in step 2, create them by entering this command:
    create index i_type3 on type$(roottoid)
    
    /
    
    create index i_type4 on type$(supertoid)
    
    /