Oracle WebCenter Content (MOSC)

MOSC Banner

how can i delete a record from the view 'GV$RESERVED_WORDS'?

edited Feb 19, 2015 10:01AM in Oracle WebCenter Content (MOSC) 2 commentsAnswered

Hi,

I want to delete the value "pt" from the view 'GV$RESERVED_WORDS' which is a Oracle Text reserved words. we are using the word "pt" as Portugal language but being a reserved word we are facing some issues in our application. Can you please let me know how can i delete the value of "pt" from the view 'GV$RESERVED_WORDS'.

I tried accessing the below query but getting the error "ORA-00942".Table or view does not exist.

<span style="font-size: 10pt;">SELECT view_definition FROM v$fixed_view_definition WHERE view_name='GV$RESERVED_WORDS';</span>

<span style="font-size: 10pt;">Thanks in advance.</span>

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