Create Schemas at Master Sites

Before you can create a master group at multiple master sites, the schemas used by the master group must exist at each site.

The Master Sites for Replication Wizard, described in Setting Up Master Sites is the preferred method for creating the required schemas. However, you can create them manually also.

Following are examples of manually creating the HR schema at ORC2.WORLD:

CONNECT SYSTEM/MANAGER@orc2.world;
CREATE TABLESPACE demo
DATAFILE 'demo.dbf' SIZE 10M AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE temp
TEMPFILE 'temp.dbf' SIZE 5M AUTOEXTEND ON;
CREATE USER hr IDENTIFIED BY hr;
ALTER USER hr DEFAULT TABLESPACE demo
QUOTA UNLIMITED ON demo;
ALTER USER hr TEMPORARY TABLESPACE temp;
GRANT
    CREATE SESSION, 
    CREATE TABLE,   
    CREATE PROCEDURE, 
    CREATE SEQUENCE,
    CREATE TRIGGER,  
    CREATE VIEW,   
    CREATE SYNONYM,  
    ALTER SESSION,  
    CREATE MATERIALIZED VIEW,
    ALTER MATERIALIZED VIEW, 
    CREATE DATABASE LINK, 
TO hr;