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
User für den Connect Through anlegen:
<code sql>
create user cman_tdm identified by "SecretPWD2023";
gran... ications-User anlegen und berechtigen:
<code sql>
create user gpipperr identified by "GanzAnderesPWD2023";...
mkstore -wrl /opt/oracle/wallet/wallet-cman-tdm -create
# User PWD für den Service hinterlegen
mkstore -... Case ===
HR User anlege und granten:
<code sql>
create user hr identified by gpi;
create user hr identif
der DESTINATION DB TST:
<code sql>
-- DB Link
create database link DP_TRANSFER connect to system ident... ed by hugo1oguh using 'gpi_db1';
-- DB Directory
create or replace directory import_dir as '/opt/oracle/i... ode sql>
ORA-39083: Object type TRIGGER failed to create with error:
ORA-00942: table or view does not exi
through auf diesen User erlauben===
<code sql>
#create minimal user
create user gpi identifed BY gpi;
grant create session to gpi;
#alter the target user that GPI can connect as
/code>
==DB Link in der DB anlegen==
<code sql>
CREATE DATABASE LINK MSSQL01 CONNECT TO "sa" IDENTIFIED ... r Linux beschrieben
* DB Link anlegen <code sql>create database link dg4Netbox connect to "dbuser" ident
alter session set NLS_LENGTH_SEMANTICS=CHAR;
SQL>create table gt ( a varchar2(10));
SQL>desc gt
Name ... alter session set NLS_LENGTH_SEMANTICS=BYTE;
SQL>create table gt ( a varchar2(10));
SQL>desc gt
Name