Database Administrator

The following script creates two tables:  read_alert  and read_alert_disk . read_alert_disk  is an  external table  and contains the con...

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

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

set pagesize 0 set linesize 30000 set long 500000 set longchunksize 500000 set trimspool on set feed off ------------Drop Database...

CREATE TABLE EMP (EMPNO VARCHAR2(10),ENAME VARCHAR2(20), SAL VARCHAR2(10), JOB VARCHAR2(10) ,HIREDATE DATE,DEPTNO VARCHAR2(10));  INSER...

SET HEADING OFF spool c:\temp\invalid.sql ; select OBJECT_NAME from dba_objects where STATUS='INVALID'; select 'ALTER ' || O...

SELECT 'SELECT COUNT(*),' || wm_concat(column_name) || ' from ' ||table_name || ' group by ' || wm_concat(column_nam...

set pagesize 1000 set lines 100 col sid format 9999 col username format a12 col module format a30 column pga_memory_mb format 9,999.99 headi...

Step : 1 Calculate total Size of tablespace select sum(bytes)/1024/1024 "TOTAL SIZE (MB)" from dba_Data_files; Step : 2 Calculate ...

GET_DEPENDENT_DDL(object_type, base_object_name, base_object_schema, version, model, transform, object_count) GET_GRANTED_DDL(object_typ...

SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE se...

set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\temp\roles_creation.sql SELECT 'Create Role ...

expdp userid="'sys/oracle@ari1112srv as sysdba'" FULL=y directory=dpump_dir2 dumpfile=ari1112.DMP LOGFILE=ari1112.LOG expd...

1) ALTER TABLE FALEDDRCR MERGE PARTITIONS BR1000, BR1050 INTO PARTITION BR1050 tablespace USR; ALTER TABLE FALEDDRCR MERGE PA...

SPOOL C:\CONS.TXT select 'select '||cc.column_name- ||' from '||c.owner||'.'||c.table_name- ||'...