Database Administration (MOSC)

MOSC Banner

SQL statement not fully shown in V$ views

edited Sep 26, 2016 1:18PM in Database Administration (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center