- Data Pump, SQL *Loader, SQL Developer, Oracle GoldenGate, Oracle Data Integrator, and other ETL tools.
- Using logical online migration, which automates the usage of Data Pump combined with Oracle GoldenGate.
- An OCI Object Store bucket.
- No, in Autonomous Database, we cannot create new tablespaces. It is restricted; we can only remap tablespaces during import. There are two tablespaces available, one for
DATAand another for
RECO. Besides that, in the ZDM migration method, we just have to provide the inputs in the response file, where we can also use
remap_tablespaceand let the ZDM tool take care of the import operation.