Skip to main content

Oracle 12c

1. Allgemein

CWK benutzt 3 Schemen und 2 Tablespaces in der exxdb1

Passwörter im Serverpool

1.1. Anlegen von Tablespace und Schematas

tablespaces
CREATE TABLESPACE RAPID_RELAY_DATA DATAFILE '/opt/oracle/oradata/exxdb1/rapid_relay_data.dbf' SIZE 200M AUTOEXTEND ON NEXT 200M MAXSIZE UNLIMITED;
CREATE TABLESPACE RAPID_RELAY_INDEX DATAFILE '/opt/oracle/oradata/exxdb1/rapid_relay_index.dbf' SIZE 5M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;
Schemata
CREATE USER RAPID_RELAY_PARAMETER IDENTIFIED BY xxxx DEFAULT TABLESPACE RAPID_RELAY_DATA TEMPORARY TABLESPACE temp QUOTA 5M ON RAPID_RELAY_DATA;
CREATE USER RAPID_RELAY_MASTER IDENTIFIED BY xxxx DEFAULT TABLESPACE RAPID_RELAY_DATA TEMPORARY TABLESPACE temp QUOTA 5M ON RAPID_RELAY_DATA;
CREATE USER RAPID_RELAY_USER IDENTIFIED BY xxxx DEFAULT TABLESPACE RAPID_RELAY_DATA TEMPORARY TABLESPACE temp QUOTA 5M ON RAPID_RELAY_DATA;
Berechtigungen
-- RAPID_RELAY_PARAMETER
GRANT "CONNECT" to RAPID_RELAY_PARAMETER;
ALTER USER RAPID_RELAY_PARAMETER default role all;
grant create session, create trigger to RAPID_RELAY_PARAMETER;
-- RAPID_RELAY_MASTER
GRANT "CONNECT" to RAPID_RELAY_MASTER;
ALTER USER RAPID_RELAY_MASTER default role all;
grant create session, create trigger to RAPID_RELAY_MASTER;
-- RAPID_RELAY_USER
GRANT "CONNECT" to RAPID_RELAY_USER;
ALTER USER RAPID_RELAY_USER default role all;
grant create session, create trigger to RAPID_RELAY_USER;

1.2. Import

impdp SYSTEM@exxdb1 SCHEMAS='RAPID_RELAY_MASTER' directory=DATA_PUMP_DIR dumpfile=CWK02_RAPID_RELAY_MASTER.dmp logfile=impdp_rapid_relay_master.log
 
impdp SYSTEM@exxdb1 SCHEMAS='RAPID_RELAY_PARAMETER' directory=DATA_PUMP_DIR dumpfile=CWK02_RAPID_RELAY_PARAMETER.dmp logfile=impdp_rapid_relay_parameter.log

Login Test

image.png

No comments to display

Back to top