8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Automatic Diagnostics Repository (ADR) Enhancements in Oracle Database 12c (ADRCI)


12c ddl ... blurgh! said...

DDL logging is all well and good, but not when they rip it out of v$sql :-(

session1:
SQL> create table T0 as select * from bigtable where col select sql_fulltext
2 from v$sql
3 where sql_id = '3bkrnakxtgdsk';

SQL_FULLTEXT
------------------------------------
create table T0 as s

truncation grrrrr!!!!!

Tim... said...

Hi.

Are you sure you don't just have your LONG set incorrectly? CLOBs get truncated by SQL*Plus by default. I've just checked V$SQL and it looks fine.

SET LONG 1000000
SELECT clob_value FROM table;

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.