Wednesday, July 29, 2020

ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small

›
ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small Sometimes you get this error if you insert a character/string i...

ORA-00600 internal error code, arguments [qkebCreateConstantOpn1]

›
Query UPDATE TBLNONPOASTOCKS SET NQUANTITY=0,NUSABLEPLEDGESTOCK=0 WHERE TBLNONPOASTOCKS.CFIRMNUMBER=ICFIRMNUMBER AND TBLNONPOASTOCKS.CPERSON...
Saturday, July 25, 2020

ORA-22992 cannot use LOB locators selected from remote tables

›
SELECT * FROM TBLHTMLSCANNEDIMAGE@LNK_PREVIOUSYEARBALANCE; ORA-22992: cannot use LOB locators selected from remote tables both 1920 and 2021...

ORA-65510: Distributed LOB operations are not supported on pre-12.2 databases.

›
Summary from LD , I m trying to save Blob image in ccm's table with link select * from ldccm.TBLCLREQUESTDESCRIPTION@Lnk_Ccm; Error 01~E...
Thursday, July 23, 2020

ORA-30926 unable to get a stable set of rows in the source tables

›
ORA-30926: unable to get a stable set of rows in the source tables   Cause: A stable set of rows could not be got because of large dml activ...
Monday, July 20, 2020

ORA-00600 internal error code, arguments [13013] [5001]

›
ORA-600 [13013] [a] [b] [c] [d] [e] [f] This format relates to Oracle Server 8.0.3 to 10.1 Arg [a] Passcount Arg [b] Data Object number Arg ...

Disable trigger based on some condition

›
/* following command will disable the RK Trigger at NON RK Client only */ declare lchost varchar2(100);  begin select host into lchost from ...

Merge is not using Parallel hint

›
if you are using table alias then use parallel(alias) not parallel(table_name) also if query is using index in plan then it will not use par...
Friday, July 17, 2020

DBCA Ora-03113

›
Check OS level Resource RAM

copy column from same table

›
Table 1 Col1 Col2 Col3 New column Col4 added Col4 has same data col2 Method Update table1 set Col4=col2 Create table as  Insert into table2(...

oracle communication: failed to connect to server or failed to parse connect string

›
Tnsping Antivirus and firewall exclusion Oracle database and application driver version compatibility ODAC ODP.NET oracle client oracle.mana...
Thursday, July 16, 2020

Update millions of rows in very huge table Performance

›
/*Use set value also in where clause. Eg. Set nUsablePledgestock=1 Where nUsablePledgestock !=0 "/ Update PowerofAttorneystocks set nUs...

select max from large table performance

›
Select max(ddate) from transactions where code='KSH'; Change to  Select ddate from ( select ddate from transactions where code='...

ORA-22816: unsupported feature with RETURNING clause in trigger

›
Restrictions The following restrictions apply to the RETURNING clause: The expr is restricted as follows: Each expr must be a simple express...

ora-02055 ora-02069 ora-06512 ora-04088 select Sequence Remote table

›
Error in executing Trigger  /* problem */ can not use Sq_Rakshakfreshpledge.nextval direct in remote table Insert into tblRkfreshpledge@lnk_...

Trigger Row Level :OLD and :NEW

›
Row level triggers can access new and existing values of columns using the ":NEW.column-name" and ":OLD.column-name"  re...
Wednesday, July 15, 2020

Database Decommission Steps

›
1)Before stopping the database double check with customer.also take backup of database for rollback plan 2)Stop database 3)Drop asm diskgrou...
Tuesday, July 14, 2020

Merge Statement on same table

›
MERGE INTO CLEMAILDETAIL t2 USING dual on (t2.firmnumber = :firm and t2.oowncode= :code) WHEN MATCHED THEN   UPDATE SET         t2.cclientle...
Friday, July 10, 2020

Performance Tips for select count update insert

›
Use Merge command Avoid select count statement. Always minimize and simplify your query. Don't make it complex.  Minimize the execution ...

10.2.0.4 to 11.2.0.4 upgrade Manually

›
Take a full backup of the database. E:\oracle\product\10.2.0\db_1\BIN\expdp.exe ldbo\bold@apx1213srv full=Y dumpfile=apx1213expdp.dmp logfil...