update nls_database_parameters Oracle

Question

update nls_database_parameters Oracle

Navigation

#1 by (2 votes)

0

I need to change the parameters nls of Oracle, putting the characteristics of the image below:

I've tested a lot of tips, but it always says I have insufficient privileges.

These are my settings:

NLS_LANGUAGE    AMERICAN
NLS_TERRITORY   AMERICA
NLS_CURRENCY    $
NLS_ISO_CURRENCY    AMERICA
NLS_NUMERIC_CHARACTERS  .,
NLS_CHARACTERSET    AL32UTF8
NLS_CALENDAR    GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE   AMERICAN
NLS_SORT    BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT    DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT  HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY   $
NLS_COMP    BINARY
NLS_LENGTH_SEMANTICS    BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET  AL16UTF16
NLS_RDBMS_VERSION   11.2.0.2.0

sql oracle

asked by anonymous 18.09.2018 / 12:50

1 answer

Redirection of sum result in JSP servlet How to recognize the selected Entry

score 2 · Answer 1

I believe the answer lies in your comment. If the error is related to insufficient privileges, your user is not authorized to change the parameters. Regardless of the method used, the database server will bar the change.