can be
installed and used on a machine different from the machine where the Oracle Database is installe... Changed database context to 'ORATST'.
1> select * from dual;
2> go
FROM_X
--------------------------------------------------
(0 rows affected)
1> insert into dual (from_x) values ("X");
2> go
(1 rows affected)
1> sel
DATABASE_ROLE,LOG_MODE,FORCE_LOGGING,FLASHBACK_ON from v$database;
DATABASE_ROLE LOG_MODE FORCE_... gs anlegen
-- prüfen mit;
select GROUP#,MEMBER from v$logfile where type='STANDBY';
GROUP# MEMBE... / as sysdba
sql>create pfile='d:\initVDSSB.ora' from spfile;
</code>
Erzeugte initVDSSB.ora und pass... 1g R2 mit RMAN "DUPLICATE TARGET DATABASE TO xxxx FROM ACTIVE DATABASE unter Linux " klonen]]
==Primary
y=?
select to_char(sysdate,'YYYYMMDDHH24MISS') x from dual;;
set termout on
spool &y._spool.log
-- hi... dd_mm_yyyy_hh24_mi')||'.log'
as SPOOL_NAME_COL
from dual
/
prompt
spool &&SPOOL_NAME
------
prompt ... y=?
SELECT SYS_CONTEXT('USERENV','SERVER_HOST') x FROM dual;
SET sqlprompt "_USER'@'_CONNECT_IDENTIFIER-... R_HOST')" könnte auch "select lower(HOST_NAME) x from v$instance;" verwendet werden, das darf aber dann
, a.name
, a.value
, a.SYSTEM_CREATED
from V$ASM_ATTRIBUTE a
inner join v$asm_diskgro... .FAILGROUP
, d.name as DISK_NAME
, d.path
from v$asm_disk d
inner join v$asm_diskgroup g... 2) as mb_bytes
, a.name as file_name
from v$asm_file f, v$asm_alias a, v$asm_diskgroup dg
... at a35
select HEADER_STATUS,MOUNT_STATUS,PATH
from v$asm_disk where HEADER_STATUS !='MEMBER';
_name
, status
, version
, schema
from dba_registry
/
column parameter format a30
column value format a30
select * from v$option
/
</code>
Wo finde ich mehr Informati... s;
EXEC sysman.setEMUserContext('',5);
REVOKE dba FROM sysman;
DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN'
;
BEGIN
ner
,object_type
,count(*) as anzahl
from all_objects
where status!='VALID'
group by roll... iele Einträge enthält:
<code sql>
select count(*) from aud$;
-- falls ja und die Daten NICHT benötigt w... code sql>
sqlplus / as sysdba
sql>SELECT version FROM v$timezone_file;
4
sql>@utltzuv14.sql
sql>select * from sys.sys_tzuv2_temptab
</code>
Falls keine Zeile
1g R2 mit RMAN "DUPLICATE TARGET DATABASE TO xxxx FROM ACTIVE DATABASE " klonen]]] kann nicht durchgefüh... gpi.UP_DATE_19C AS SELECT sysdate AS UPDATE_DATE FROM dual;
</code>
* Backup der letzen Archive Logs ... ql>rman
connect target /
rman>restore controlfile from autobackup;
# alternativ
rman>restore controlfile from ’f:\backup\name…..’ --hier das aktuellste contro
erwachen:
<code sql>
SELECT DBMS_SCHEDULER.STIME FROM DUAL;
STIME
------------------------------------... OPE/BERLIN');
END;
/
SELECT DBMS_SCHEDULER.STIME FROM DUAL;
STIME
------------------------------------... -- nur im Job Log steht ein Eintrag!
select *
from dba_scheduler_job_log
where job_name = 'CLEAN_SQL... Lightwight Job wird weiterverwendet
select *
from dba_scheduler_programs
where program_name = 'CL
per Default nicht indiziert:
<code sql>
SELECT * FROM ctxsys.ctx_stopwords
WHERE spw_stoplist LIKE '... e Syntax:
<code sql>
SELECT id
, SCORE(1)
FROM TEXTE
WHERE CONTAINS(COLUMN, 'query_string',1)>0... sy Suchen in der ausführlichen Variante
SELECT * FROM texte WHERE contains(text, 'fuzzy(Hunt, 50, 50, W... omp_name, status, substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';
select *
m/2019/07/10/invalid-system-views-after-upgrading-from-12c-to-18c-x_kglob-and-x_kglcursor/
Prüfen ob ... en!
<code sql>
select password_versions,username from dba_users where password_versions like '%10G%';
<... ord Datei in Verwendung ist:
<code sql>
select * from v$pwfile_users;
-- SYS muss dabei sein!
</code>... s.
</code>
Version prüfen:
<code sql>
select * from v$timezone_file;
FILENAME
UN_DATE, 'DD.MM.YYYY HH24:MI') as NEXT_RUN_DATE
from dba_scheduler_jobs
where job_name like '%STAT%' ... YY HH24:MI') as actual_start_date
,error#
from dba_scheduler_job_run_details
where JOB_NAME = '... ', '<==CHECK IF POSSIBLE', '-') as check_active
from dba_scheduler_windows
order by last_start_date
/...
,window_next_time
,autotask_status
from dba_autotask_window_clients
/
ttitle left "Ch
|'er Wert');
end loop;
commit;
end;
/
select * from T_IOT1
/
# alles wird aus dem Index gelesen:
A... ndex organised','heap organised') as TABLE_TYPE
from dba_tables
where table_name like upper('&ENTER... TS liefert KEINEN Treffer!
<code>
select count(*) from DBA_SEGMENTS where segment_name like 'T_IOT1';
... ----------
0
select count(*) from DBA_EXTENTS where segment_name like 'T_IOT1';
------------------------------
-- clean string from whitespaces to avoid sql injection
--+ --------... ----------------------------------
-- get a key from the local db enviroment
-- The encryption key f... har2 (2000) := 'PWD';
begin
-- get some ids from default objects, that not chaning so often .-)
... ct to_char (object_id)
into v_obj_id1
from user_objects
where object_name = 'ENCRYPT_UT
PI - Gunther Pippèrr
-- Desc: create AWR report from sql*Plus
-- Date: 10.2015
--====================... time,'hh24:mi dd.mm.yyyy') as end_interval_time
from dba_hist_snapshot
where end_interval_time > trun... .html','\','_')
--' resolve syntax highlight bug FROM my editer .-(
AS SPOOL_NAME_COL
,SYS_CONTEXT('USERENV','INSTANCE') as instance_number
FROM dual
/
select dbid as aktdbid
from v$database