Oracle Exadata Hybrid Columnar Compression (HCC or EHCC) is a storage-dependent compression format. It is supported on Exadata and selected Oracle storage platforms, including Oracle ZFS Storage Appliance, Pillar Axiom, FS1, SuperCluster, and Oracle Database Appliance (latest releases). It is not supported on ordinary third-party or non-Exadata storage. If you have a Data Pump export … Continue reading Migrating Oracle HCC-Compressed Tables to Non-Exadata with Data Pump
Is it possible to map one Tablespace to many Tablespaces with impdp?
I got this question from one of my clients. He is going to migrate one database from one platform to another. In this database many users are sharing the same tablespace. For example: In the current database, all application users are sharing the tablespaces “USERS” The client wants to change this, so as each schema … Continue reading Is it possible to map one Tablespace to many Tablespaces with impdp?