Oracle – Rodrigo Silva e Silva

How to drop database In oracle 11g/12c /18c/19c/21c Without Using DBCA

Publicado em 29 de novembro de 2021 by rodrigosilvaesilva

Export SID instance droped Connect database as sysdba Check status instance Shutdown the database startup in exclusive mode restrict Check status instance Drop database

Dropping redo log group thread Migrate RAC to Single

Publicado em 31 de agosto de 202131 de agosto de 2021 by rodrigosilvaesilva

Causa Erro ao dropar redo instance migrada de Rac para Single SYS@OLTP> alter database drop logfile group 10;alter database drop logfile group 10*ERROR at line 1:ORA-01567: dropping log 10 would leave less than 2 log files for instance oltp2 (thread 2)ORA-00312: online log 10 thread 2: ‘/u01/oracle/oradata/OLTP/redo_10.log’ Consultando Group Redo / Threads Consultando as threads…

Expdp Oracle 11G ORA-39001: invalid argument value, ORA-01775: looping chain of synonyms

Publicado em 3 de julho de 2021 by rodrigosilvaesilva

Cause Fail export or impdp ORA-39001: invalid argument valueORA-01775: looping chain of synonyms ORA-39001, 00000, “invalid argument value”// *Cause: The user specified API parameters were of the wrong type or// value range. Subsequent messages supplied by// DBMS_DATAPUMP.GET_STATUS will further describe the error.// *Action: Correct the bad argument and retry the API. Query Dba Objects Solution…

How to extract DDL for User including Privileges and Roles using dbms_metadata.get_ddl

Publicado em 10 de junho de 2021 by rodrigosilvaesilva

Connect Database and Execute with user DBA privilege Put username in uppercase References NOTE:207859.1 – Object types for DBMS_METADATANOTE:1460969.1 – How To Retrieve The Full Object Definition (DDL) From The DatabaseNOTE:1163383.1 – The dbms_metadata.get_granted_ddl Does Not Extract all System Privileges

Listando conteúdo Job

Publicado em 13 de julho de 202019 de março de 2021 by rodrigosilvaesilva

Query

select owner as schema_name,
       job_name,
       job_style,
       case when job_type is null 
                 then 'PROGRAM'
            else job_type end as job_type,  
       case when job_type is null
                 then program_name
                 else job_action end as job_action,
       start_date,
       case when repeat_interval is null
            then schedule_name
            else repeat_interval end as schedule,
       last_start_date,
       next_run_date,
       state
from sys.all_scheduler_jobs
order by owner,
         job_name;

select owner as schema_name,

job_name,

job_style,

case when job_type is null

then 'PROGRAM'

else job_type end as job_type,

case when job_type is null

then program_name

else job_action end as job_action,

start_date,

case when repeat_interval is null

then schedule_name

else repeat_interval end as schedule,

last_start_date,

next_run_date,

state

from sys.all_scheduler_jobs

order by owner,

job_name;

Columns schema_name – name of the schema job_name – name of the job job_style: REGULAR LIGHTWEIGHT job_type – inline job action type PLSQL_BLOCK STORED_PROCEDURE EXECUTABLE CHAIN SQL_SCRIPT BACKUP_SCRIPT EXTERNAL_SCRIPT PROGRAM job_action – PL/SQL code or program/routine name to call start_date – when job will be launched first time schedule – inline schedule…

Posts antigos →