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...

Tom, I have a doubt about adding columns with default values to a table. Recently, I have stumble upon an Arup Nanda article on it where he states the following "When a user selects the column for an existing record, Oracle gets the fact about the default value from the data dict...