Wednesday, September 23, 2020

private dblink

›
DB ldccm User ldccm Private Dblink cmldlink connect to LD database Now how user will access ldfibs table of other database using private lin...
Friday, September 18, 2020

Calculating ages in years

›
Calculating ages in years isn't as easy as ( current date - birth date ) / 365 @connor_mc_d has a solution - convert the dates to number...
Monday, September 14, 2020

Gather Stats of Table Partition Latest/Current Month Partition

›
  BEGIN  FOR CUR_REC IN (select * from (select table_owner,table_name,partition_name,partition_position,last_analyzed from dba_tab_partition...

Kill Third Party Tool Like PLSQL Developer Session

›
BEGIN  FOR CUR_REC IN (select ss.username,ss.terminal,ss.sid,ss.serial#,ss.inst_id from gv$session ss where module='PL/SQL Developer...
Thursday, August 27, 2020

ORA-12018: following error encountered during code generation for ..ORA-00979: not a GROUP BY expression

›
 ORA-12018 ORA-00979 ORA-06512 When we create Materialized report view it is successfully created and reports are coming properly. But when ...
Friday, August 21, 2020

The message could not be dispatched because the service at the endpoint address 'net.pipe://localhost/ServiceName' is unavailable for the protocol of the address

›
Getting the error, The message could not be dispatched because the service at the endpoint address 'net.pipe://localhost/ServiceName...
Thursday, August 20, 2020

Oracle 19c Security parameters Cyber security

›
Wednesday, August 12, 2020

IIS Web Security | Cyber Security | VAPT | Best Practices

›
1) Don't use default location c: to host application 2) disable default page 3) disable directory browsing 4) Disable the Http OPTIONS M...
Sunday, August 2, 2020

ora-01843 not valid month

›
ora-01843 not valid month Date which is passing in query has wrong format. Check server date format Or Web.config (.NET application) Add fol...
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...