2 Replies Latest reply on Aug 30, 2019 9:20 PM by user13620045

    MVs are not created when impdb using remap tablespace

    user13620045

      Trying to move the objects in tablespace DATA1 to DATA3

      expdp system/dfwetwe@data Directory=PORT_DIR DUMPFILE=data1.dmp logfile=data108282019.log tablespaces=DATA1 COMPRESSION=ALL

       

      impdp system/dfwetwe@data Directory=PORT_DIR DUMPFILE=data1.dmp logfile=data108282019_imp.log remap_tablespaces=DATA1:DATA3 table_exists_action=replace

       

      Everything is moved successfully but the MVs. Only the MV data. Looks like impdb treated the MVs as regular tables. Get a sql file using impdb and cannot find the MVs creation sql inside it.

      Any idea? Thanks.