Import Oracle dump in different tablespace
Remap tablespaces when importing Oracle Data Pump dumps with REMAP_TABLESPACE on impdp.
Continue ReadingTag: oracle
Oracle connect remotely
Allow remote SQL*Net connections to Oracle Database by configuring listener.ora, tnsnames.ora, and firewall rules.
Continue ReadingOracle EM Configuration
Configure Oracle Enterprise Manager Database Express or Cloud Control for monitoring and administration.
Continue ReadingOracle Replication through Oracle Data Guard
Achieve high availability with Oracle Data Guard physical standby databases, redo transport, and role transitions.
Continue ReadingSQLPlus Snippets
Handy SQL*Plus commands for scripting, formatting output, and running reports from the Oracle command line.
Continue Reading