ouch: CTAS truncated in v$sql and v$sqlarea

January 30, 2015 — Leave a comment

11.2.0.4 on Linux x64:

alter system flush shared_pool;
drop table t1;
create table t1 as select 'grant sysdba to me' a from dual;
set long 20000
select sql_id,sql_fulltext from v$sql where sql_text like 'create table t1%';
select sql_id,sql_fulltext from v$sqlarea where sql_text like 'create table t1%';
desc t1

result:

SQL_ID	      SQL_FULLTEXT
------------- --------------------------------------------------------------------------------
dbgtudsa7v0wj create table t1 as s


SQL_ID	      SQL_FULLTEXT
------------- --------------------------------------------------------------------------------
dbgtudsa7v0wj create table t1 as s

at least there is a fix for it (19148376) if you are willing to install psu1 on top of 11.2.0.4 (which is a prereq).

No Comments

Be the first to start the conversation!

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.