Database Administrator

create or replace procedure sp_rebuildindex as   vOwner   dba_indexes.owner%TYPE;            /* Index Owner            */   vIdxName dba_...

alter tablespace temporary shrink space keep 1G; exec dbms_scheduler.drop_job('tempshrink');  begin dbms_scheduler.create_job ...

For Oracle on unix .aud files are created whether you have auditing enabled or not.  They record sys operations.  If you've got a lot o...

Dont Use PLSQL Developer, it will corrupt code bodies 1) Take Export Full Dump of apx1213 DB using Data Pump conn sys@apx1213srv as sy...

If you want to create a Database Skeleton (All tables (without Data), indexes and other objects) same as another database Then You jus...

Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) To connect Oracle to a non-Oracle system through DG4ODBC: Ins...

http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse005.htm http://www.oracle-base.com/articles/11g/scheduler-enhancements-11gr2...

The steps for 10g database: 1- Run the utlu112i.sql Pre-upgrade script. You can find this script under @$ORACLE_HOME/rdbms/admin/. It mus...

Issues with setting Local Listener ORA-00119 ORA-00132 Today I was caught up in a issue with TNS while trying to setup SOA setup with OE...

ora 12560 tns protocol adapter error database DBCA fails -------------------Most common reasons for ORA-12560 in Windows are-------------...

You can use the INSERT statement to insert data into a table, partition, or view in two ways: conventional INSERT and direct-path INSERT. W...

Note: This will not work from 10g to 11g version......................procedure will be corrupted set pagesize 0 set linesize 30000 se...