SQL statement not fully shown in V$ views
Hi,
When running a CTAS the full ddl statement is not shown in the different V$ views. From V$SQL, I see only this much in the sql_fulltext column:
CREATE TABLE MY_TABLE_
I've tried different views (V$SQLAREA, V$SQLTEXT_WITH_NEWLINES, etc.) but it seems I can't find the full text anywhere. In V$OPEN_CURSOR, there was a little more, but hardly 40ish characters. The CTAS is not that long, so I can't explain why it's not shown entirely.
My DB version is 11.2.0.4 EE.
Any idea?
Thanks