g und kann es verwendet werden ===
<code plsql>
set serveroutput on
declare
v_out1 varchar2(3000);
... cht ausreichend:
<code bash>
SP2-0158: Unbekannte SET-Option "show"
Zeile 676: "set SQLC MIX" ist veraltet.
SP2-0158: Unbekannte SET-Option "recsep"
Autotrace deaktiviert
</code>
----
ivate/haproxy.pem
mode http
http-request set-header X-Forwarded-For %[src]
reqadd X-Forwar... ated DH parameter.
[WARNING] 050/175637 (38926) : Setting tune.ssl.default-dh-param to 1024 by default, if your workload permits it you should set it to at least 2048. Please set a value >= 1024 to make this warning disappear.
Configuration file is
xpand_sql_text die Funktion auflösen kann:
<code>
SET SERVEROUTPUT ON
DECLARE
v_full_sql CLOB;
BEGIN... keinen Sinn ...
-- nächster Versuch:
with data_set as (
select k.Kundenname,
getInteralKDNrSQM... teralKDNr
from Kunden k
)
select *
from data_set
group by Kundenname
, InteralKDNr
SQL... über **DBMS_UTILITY.expand_sql_text**
<code sql>
SET SERVEROUTPUT ON
DECLARE
v_full_sql CLOB;
BEGIN
h>
timedatectl
#falls es nicht passt
timedatectl set-timezone Europe/Berlin
</code>
Für die eigentli... space für APEX anlegen:
<code sql>
ALTER SESSION SET CONTAINER = ans;
CREATE TABLESPACE APEX DATAFIL... RESTRICTED, OPEN_TIME FROM V$PDBS;
ALTER SESSION SET CONTAINER = FREE;
SHOW CON_NAME
</code>
=== ... **$CATALINA_HOME\conf** Verzeichnis.
==TCP Port setzen - server.xml ==
Über "server.xml" wird zum Be
cl/download/
Bei Java Fehler zuvor ein JAVA_HOME setzen!
<code bash>
export JAVA_HOME=/usr/lib/jvm/jd... standalone mode
[2] Skip
Choose [1]: 2
The setting named: db.connectionType was set to: basic in configuration: default
The setting named: db.hostname was set to: 10.10.10.90 in configur
L_STORE', 'multi_column_datastore' )
exec ctx_ddl.set_attribute ( 'GPI_MULTI_COL_STORE', 'columns', 'kd_name, anschrift, bemerkung' )
exec ctx_ddl.set_attribute ( 'GPI_MULTI_COL_STORE', 'filter', ... n t1
for each row
begin
update search_master set CHANGE_DATE=to_char(sysdate) where PK_TABLENAME='... n t2
for each row
begin
update search_master set CHANGE_DATE=to_char(sysdate) where PK_TABLENAME='
r Password =====
=== DB User Datenbank Password setzen ===
Auf die Zieldatenbank als SYS anmelden und das User Passwort setzen
<code sql>
ALTER USER ords_public_user IDENT... nter the database password:
Confirm password:
The setting named: db.password was set to: ****** in configuration: default
</code>
<note important>ORDS N
Anzahl der Mails pro Tag auf Instance Ebene höher setzen, Default 1000, für produktive Umgebung meist z... e:
{{ :prog:apex:apex_22_3_mail_versandt_instance_settings.png?600 | Mail Settings auf Instance Ebene}}
Prüfen ob der APEX Mail Job alle 5 Minuten auch wi... -----------------------------------------
-- Set Apex Workspace ID and Security Group ID
SELEC
OME/bin
./ords --config /srv/ords/config/ config set --global instance.api.enabled true
ORDS: Release... Oracle.
Configuration:
/srv/ords/config/
The setting named: instance.api.enabled is not a recognized configuration setting. Run: ords config info to get a list of known configuration settings
The global setting named: instance.api.enabl
-- put in your workspace
apex_util.set_security_group_id (p_security_group_id => apex_ut... END IF;
$END
END;
/
--- testen
set serveroutput on
begin
dbms_output.put_line('-- In... EX - Package variable g_security_group_id must be set ====
Fehler:
<code sql>
ORA-20987: APEX - Package variable g_security_group_id must be set. - Contact your application administrator.
</code
ere Verbesserung der Laufzeit ließ sich durch das Setzen von NLS Sort auf binary erreichen
<code sql>
alter session set nls_sort=binary;
# Gut - Laufzeit ca 3 Minunte, w
QL Script um die Daten zu ermittlen:
<code sql>
set long 2000000;
set pagesize 0
set linesize 2300
set heading off
set echo off
set feedback off
-- define the name of the spoolfile
set t