Database Administrator

You can implement advanced compression option into your databases having more update, insert operation tables to manage high growing amoun...

d:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\admin\utlexcpt.sql create table exceptions(row_id rowid,                owner varch...

Create or Replace TRIGGER TG_OTHER_TOOL   v_prog sys.v_$session.program%TYPE;   v_module sys.v_$session.program%TYPE ; lnUsercode number...

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

create or replace procedure sp_ltmlogin AS   MODULE SYS.V_$SESSION.MODULE%TYPE ; L_USER NUMBER ; BEGIN  SELECT MODULE INTO MODULE FROM ...

create or replace trigger tg_dropuser before drop on database when (ora_dict_obj_type ='USER')   declare  l_name varchar2(30); ...

In regular object-based auditing, the records can show that a user selected from a specific table, along with other helpful information such...

select name,value,isdefault,isses_modifiable,issys_modifiable, isinstance_modifiable,isdeprecated, from v$parameter; alter system reset...

create table table1 (startdate date,CloseDate date); ALTER TABLE Table1 ADD (CONSTRAINT GT_Table1_CloseDate CHECK (CloseDate > SYSDA...

cmd>reg add "HKCU\Software\Microsoft\Office\12.0\Excel\Security" /v AccessVBOM /t reg_dword /d 1 /f Microsoft.Win32.Registr...

cmd> REG ADD "HKCU\Control Panel\International" /v sShortDate /d "dd/MM/yyyy" /f Microsoft.win32 Namespace is con...

1) void AddToFirewallException(string ApplicationName, string FilePath)         {             // Add exception to windows firewall after...

how can i get the start date n end date of quarter?eg. if i pass date as 30/07/2012 then start date should be 01/07/2012 to 30/09/2012,If i...

create or replace trigger TG_SINGLELOGIN after logon on database declare cnt pls_integer; begin select count(*) into cnt from v$sessio...

create or replace trigger TG_MULTILOGIN after logon on database declare cnt pls_integer; begin select count(*) into cnt from v$session...

suppose you have five machines and five users (   one user per machine ) Note: these users are database users... e.g User name ...

----------------------------------------------------------------------------------------------------------------------- connect sys as sy...