Things are different in Oracle Database 12c with multitenancy option. My most recent example: I tried to import a schema (new name “NEWSCHEMA”) with datapump IMPDP and REMAP_SCHEMA into the same pluggable database it has been exported from with EXPDP immediately before (name “OLDSCHEMA”), running as SYSTEM. I’m doing things like that with DBA permissions, since […]
About
Martin Klier
Troubleshooter, Database integration, performance and HA specialist with 15+ years of experience. Oracle ACE Director.
co-founder of performing databases.
Your data efficiency experts.
