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

Advertisements

No Comments

Be the first to start the conversation!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s