Solved

Change ORACLE DB Gregorian / Persian calender...

Posted on 2014-09-13
1
596 Views
Last Modified: 2014-09-28
Hi,
I'm using ORACLE 11g XE (express edition)
I need to replace the Gregorian calender with the Persian calender settings...
And how to convert the existing data?
Thank you in advance,
Best
Andreja
0
Comment
Question by:andrejaTJ
1 Comment
 
LVL 34

Accepted Solution

by:
johnsone earned 500 total points
ID: 40320757
I don't have a version of XE that I could test this on, but from what I have found, this is controlled by the NLS_CALENDAR parameter.  No conversion of data should be necessary.  In order to see of XE supports the parameter, I would try this command in SQL*Plus:

ALTER SESSION SET NLS_CALENDAR='Persian';

If that works you should be able to change it in the init.ora.  It has been a while since I used any version of XE, so you could try this:

ALTER SYSTEM SET NLS_CALENDAR='Persian' scope=both;

You could also set this on the client side.  If you are using Windows as a client, you should be able to change it in the registry on the client and set the value that way.

For reference, the documentation on that parameter is here -> http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams144.htm#REFRN10116
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

937 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now