Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Get the length of CLOB columns in bytes

    Hello Tom, I have a table with a CLOB column: create table plch_clob (i int primary key, x clob); begin for indx in 1 .. 1000 loop insert into plch_clob( i, x) values (indx, 'CLOB Row: ' || indx); end loop; commit; end; By calling the functi
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Configure ORDS with VPD OR RAS

    Hello everyone At first, I have an angular UI client and ORDS as API. I'm going to use RAS(real application security) or VPD for row-level security. I read oracle RAS documentation and I didn't catch how to use it with ORDS(without apex) and this is true for using VPD, I created ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    "alter session sync with primary" with Maximum Performance Protection Mode

    "alter session sync with primary" raises ORA-03173 for us. SQL> select database_role, open_mode, db_unique_name from v$database; DATABASE_ROLE OPEN_MODE DB_UNIQUE_NAME ---------------- -------------------- ------------------------------ PHYSICAL STANDBY READ ONLY WITH AP
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to do update (replace values) in a table contains 50+ million records?

    Hi, I have a table contains 50+ million records, and I am writing a procedure to replace the bad data to the correct values(about 1500 records). K_V is the array of bad data and target correct value,like K_V('bad data1') := 'correct value1' when I loop the K
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ORA-12569: TNS:Packet Checksum Failure - How is this error even possible?

    Hello masters. Here I am again with another mystery from our favorite DBMS (no, that was not sarcasm, I do love Oracle in fact). So, in my company we are facing the referred error, ORA-12569: TNS:Packet Checksum Failure While Trying To Connect Through Client. The message itself i...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report