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
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
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
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
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>
----