Hi Team, While using a connection to database A, is it possible to automatically redirect a SQL query to execute on database B, as if the query was modified to have database links added to all objects? We have a reporting application for an ERP system called Oracle E-Business Sui...

Dear Tom, One of my tables uses the clob datatype and has a total length of roughly 70000 characters. The data is truncating at 32767 characters when I'm spooling it to a.psv file, because of the set linesize 32767. I've used the following code. SET HEADING OFF SET VERIFY OFF SET...

Hi guys, I have the following issue: -When i add a new datafile on my SAP APP at PSAPSR3 tablespace with 1Gb for example and with maxsize of 30GB after 2 minutes Oracle resize the datafile to 30GB, if i resize again to 1GB 2 minutes after oracle resize again to 30GB. This behavio...

Hi Team, Any idea, why generic path expression based renaming of JSON fields does not work? A sample- 1. Below function transform top layer, but leaves nested layer. <CODE> Select JSON_TRANSFORM('{"field_a": 2, "field_b": 3 , "nested" : {"nested1":{"field_a":2, "field_b":3 }}}', ...

Hi Tom, Presently, it is not possible to replace a part of a LOB (the DBMS_LOB package does not have a replace function). The write procedure overwrites. Is it possible, if not why, to write at a certain position (not append) and offset the remaining portion while not overwriting...