Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Setting Init Param NLS_TIMESTAMP_FORMAT and NLS_DATE_FORMAT

46571Mar 15 2005 — edited Nov 16 2005

I need to set NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT to new values, and can't figure out how to do it as an initialization parameter. What I did with my 9.x databases was to set it in the init.ora file before I turned it into an SPFILE. Now, in 10g, with the DBCA making an SPFILE for me in a way I can't do things in the middle of (where did 9.2.x's DBCA's creation scripts go, anyways?), I have a nice new database with a nice SPFILE with parameters I can't change.

The web-based OEM won't let me change them.

Help...

Kevin

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2005

Added on Mar 15 2005

#general-database-discussions

5 comments

955 views