Database Administration (MOSC)

MOSC Banner

SQL_FULLTEXT column for v$sql showing truncated output after upgrade from 11.2.0.2.5 to 11.2.0.4.1

edited May 14, 2014 2:33PM in Database Administration (MOSC) 1 commentAnswered

Hi All,

We are observing this behavior only for "CREATE TABLE AS" statements. Below is one example.

"create table test as select * from country_admin.event;" was the statement run in our environment and SQL_FULLTEXT shows only below data :-

"create table test as"

Can someone please suggest.

Thank you

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