Saturday, July 27, 2013

Grant role access to all objects in a schema to another user

›
BEGIN FOR i IN (SELECT object_name FROM user_objects WHERE object_type in ('PROCEDURE','PACKAGE','FUNCTION') ) LOO...

Sessions Hang On Wait Event WAIT FOR EMON PROCESS NTFNS ID 1287435.1

›
Sessions Hang On Wait Event "WAIT FOR EMON PROCESS NTFNS" [ID 1287435.1] Symptoms RDBMS 10.2.0.4.0 OCI based DB change noti...

Bug 8605337 - Deadlock between gather stats job and concurrent DDL [ID 8605337.8]

›
Bug 8605337  Deadlock between gather stats job and concurrent DDL Product (Component) Oracle Server (Rdbms) Range of versions believe...

ORA-00439 feature not enabled Deferred Segment Creation 11g enterprise to standard edition downgrade

›
1293326.1 http://lifeandoracle.blogspot.in/2012/07/ora-00439-feature-not-enabled-deferred.html http://ocpdba.wordpress.com/2009/10/09/d...

Oracle 11g2 does NOT export empty tables when using exp.exe

›
http://tsells.wordpress.com/2011/02/10/oracle-11g2-does-not-export-empty-tables-when-using-exp-exe/ Out of habit I have been using the old...

ORA-24330 OCI INTERNAL ERROR

›
Solution: alter system set client_result_cache_size=0 scope=spfile; Effect of client_result_cache_size On Client Applications Or OCI Ba...

Windows 7 64 bit (unable to make connect to sql data source error# -1)

›
Error in odbc.dbf : Connectivity error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener Solution:  I have changed s...

LD error money obligation cexist ORA-01422 exact fetch returns more than one requested number of rows

›
That error occurs in a SELECT ... INTO statement, when your query returns more than one row. Check your where clause, and make the necessary...

Nse Bill Data Generation cannot take place. ~-1422~ORA-01422 exact fetch returns more than requested number of rows~ORA-06512 at LDBO.PK_NSEBI

›
[Microsoft][ODBC driver for Oracle][Oracle]ORA-20014: Nse Bill Data Generation cannot take place. ~-1422~ORA-01422: exact fetch returns more...

table alias uncommitted changes

›
http://www.mofeel.net/110-microsoft-public-fox-programmer-exchange/5596.aspx http://support.microsoft.com/KB/249836 Table buffer for ali...

ORA-22288 File Or LOB Operation FILEOPEN Failed On Windows2008 R2 OS SAN Attached Drive [ID 1504521.1]

›
Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.2 and later Microsoft Windows x64 (64-bit) Symptoms Error ORA-22288: ...

ora-600 [16513] [1403]

›
http://www.sql.ru/forum/377566/vopros-pro-shutdown-abort ora-600 [16513] [1403] [20] SQL > Select count (*) from $ obj;   COUNT (*...

ORA-00350 log 3 of instance beb1314 (thread 1) needs to be archived ORA-00312 online log 3 thread 1 'EBEBD1314REDO03.LOG'

›
ORA-00350 ORA-00312 SQL> alter database drop logfile group 3; alter database drop logfile group 3 * ERROR at line 1: ORA-00350: lo...

ORA-16014 ORA-00312

›
----------ORA-16014 ORA-00312 Archive process error: ORA-16014: log 3 sequence# 29808 not archived, no available destinations ORA-00312: ...

ORA-00257Archiver Error, Connect Internal Only Until Freed and ORA-16014 and ORA-00312

›
ORA-00257Archiver Error, Connect Internal Only Until Freed and ORA-16014 and ORA-00312 [ID 376923.1] I have stop archivelog to stop error...

Problem while archiving the redo Log

›
https://forums.oracle.com/thread/977515 Hi all, I m having few issues in my server... I get the following error in the alert log of orac...

ALTER SYSTEM SWITCH LOGFILE Statement hangs

›
ALTER SYSTEM SWITCH LOGFILE Statement hangs ALTER SYSTEM SWITCH LOGFILE hangs: Step 1: Login as sysdba. Step 2: Enable log_archive_dest_s...

CreateFile error 32 when trying set file time oracle 11g windows 7

›
Today I am going to install Oracle 10g Client and ODAC11gR2 (Oracle Data Provider .Net) in Microsoft Windows XP Professional Service Pack 2....

ora-02067 transaction or savepoint rollback required

›
disable trigger THEN TRY AND ENABLE

ORA-00333 redo log read error block

›
PFILE _ALLOW_RESETLOGS_CORRUPTION = true  UNDO_MANAGEMENT = MANUAL RENAME SPFILE recover database until cancel; or RECOVER DA...