Database Administrator

CREATE OR REPLACE TRIGGER dtr_userEvents BEFORE ALTER ON SCHEMA DECLARE   l_sqlText    ORA_NAME_LIST_T; BEGIN   IF ora_dict_obj_type ...

/*restrict any software other than SQL*Plus to connect to Oracle database. */ /* Oracle Job Scheduler  DBMS_JOB */ create or replace pro...

Select 'SELECT * FROM ' || Table_Name || ' MINUS SELECT * FROM ' || Table_Name || ' WHERE ' || Search_Condition ||...

ORA-02291: integrity constraint (string.string) violated - parent key not found Cause: A foreign key value has no matching primary key v...

Purging trace and dump files with 11g ADRCI In previous versions of Oracle prior to 11g, we had to use our own housekeeping scripts t...

Automatic Diagnostic Repository Command Interface Starting with 11gR1, we have a new way to deal with Oracle Errors & Tracefiles: Th...

Our organization requires a regular password change on some database accounts for security compliance. If this account is used in the datab...

select column_name, num_nulls from all_tab_columns where table_name = 'SOME_TABLENAME' and owner = 'SOME_OWNER'; --------...

create or replace function find_in_schema(val varchar2) return varchar2 is   v_old_table user_tab_columns.table_name%type;   v_where     ...

Controlling Archive Lag You can force all enabled redo log threads to switch their current logs at regular time intervals. In a primary...

                                       Server version    Client version 11.2.0.1.0 ...