anlegen ===
**Source** DB **GPITEST**
<code sql>
create user BESTDBA identified by "xxxxxxxx";
grant conn... BESTDBA/"xxxxxxxx"
-- test daten erzeugen
SQL> create table t_all_objects as select * from all_objects;
Table created.
SQL> select count(*) from t_all_objects;
CO... *Target/Destination** DB **GPIPROD**
<code sql>
create user BESTDBA identified by "xxxxxxx";
grant conne
der DB mit dem User SYS anmelden
* Script mit @create_global_errorlog.sql starten
Was wird angeleg... der Tabelle auftauchen
**Tabelle:**
<code sql create_error_trigger.sql>
set serveroutput on size 1000... Errorlog Table / Sequence and Trigger will be created
-------------------------------------------... on size 1000000
exec DBMS_OUTPUT.put_line('start create_global_errorlog.sql');
prompt "Create Table SYST
gentlichen Job
* Anlegen mit "DBMS_SCHEDULER.create_job"
* Gehört einen Anwender/Schema der Daten... erwendet werden
* Anlegen mit "DBMS_SCHEDULER.create_program"
* Gehört einen Anwender/Schema der D... rwendet werden
* Anlegen mit "DBMS_SCHEDULER.create_program"
* Gehört einen Anwender/Schema der D... ebrochen werden
* Anlegen mit "DBMS_SCHEDULER.create_window"
* Für ein Fenster kann ein Ressource
hte vergeben:
<code sql>
sqlplus / as sysdba
-- Create the Job User
create user job_control identified by job$100;
grant connect,resource to job_control;
grant... espace to job_control;
-- grant the main rights CREATE JOB, CREATE CREDENTIAL, and CREATE EXTERNAL JOB
grant create job, create credential, create external jo
das richtige Dateiformat.
Beispiel:
<code sql>
create index idx_documents_docs on documents(docs)
... spiel inkl. Angabe des Zeichensatzes:
<code sql>
CREATE TABLE documents ( id NUMBER(11)
... , docs BLOB
);
CREATE INDEX idx_documents_docs ON documents(docs)
... ufgerufen werden soll.
<code sql>
begin
ctx_ddl.create_preference
(
preference_name => 'USER_FILT
Owner muss das Rechte gebenen werden:
* grant create procedure to <package_owner>
* grant create type to <package_owner>
Die Spezifikation:
<code plsql encrypt_util_spec.sql>
create or replace package encrypt_util
as
crypt_value... /code>
Body:
<code plsql encrypt_util_body.sql>
create or replace package body encrypt_util
as
--+ ---
aber dann doch keinen rechten Sinn =>
<code sql>
CREATE diskgroup DATA01 EXTERNAL REDUNDANCY disk 'AFD:D... *
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15099: disk 'AFD:DWHDATA1' is larger than ma... t compatible 19 läßt sich das umgehen:
<code sql>
CREATE diskgroup DATA01 EXTERNAL REDUNDANCY disk 'AFD:D... v/sdb1
</code>
siehe auch "How to configure and Create a Disk group using ASMFD (Doc ID 2053045.1)"
==
n bricht mit folgendem Fehler ab:
<code>
...
ASM created and started successfully.
Disk Group VOT mounte... meiner Umgebung mit setdb 1
sqlplus / as sysasm
create diskgroup redob external redundancy disk '/dev/oracleasm/disks/red02' attribute 'au_size'='1m' ;
create diskgroup data external redundancy disk '/dev/o... racleasm/disks/data01' attribute 'au_size'='4m' ;
create diskgroup fra external redundancy disk '/dev/o
stellen und im eigenen Schema testen
<code sql>
create database link temp_test connect to prod_user iden... >
=== Hilfsfunktion erstellen ===
<code sql>
create or replace procedure ANWENDER_A.create_a_db_link
as
begin
execute immediate 'create database link temp_test connect to prod_user identified
hte vergeben:
<code sql>
sqlplus / as sysdba
-- Create the Job User
create user job_control identified by job$100;
grant connect,resource to job_control;
grant... -u 1102 -g etl job_control
passwd job_control
# Create directory for the ETL scripts
mkdir /srv/job_con... ba
-- Credentials anlegen
BEGIN
DBMS_SCHEDULER.CREATE_CREDENTIAL(
'FILE_WATCH_CRED'
, 'jo
tecture}}
After some snapshots it is possible to create the differential report over the values inside th... Install Oracle statspack ====
Prerequisites:
* create table space for the statspack repository (or deci... with "/ as sysdba". The user **PERFSTAT** will be created. This user is the owner of the statspack reposit... CLE_HOME/rdbms/admin
sqlplus / as sysdba
sql>@spcreate.sql
# define password for the perfstat user
# ch