Showing posts with label Globalization. Show all posts
Showing posts with label Globalization. Show all posts
Wednesday, August 2, 2023

What are the DST time zone files ?

›
What are the Oracle Time Zone files? The Oracle Database time zone files contain the valid time zone names. The following information i...
Tuesday, September 18, 2018

How the DBTIMEZONE is set in an Oracle database

›
A customer wanted me to look into why his two databases running the exact same application code were returning different time zones. sele...
Wednesday, April 18, 2018

Potential solution for ORA-12008: error in materialized view or zonemap refresh path

›
During the synch-phase of an online redefintion, I received the error: begin ORA-42009: error occurred while synchronizing the redefiniti...
1 comment:
Friday, April 7, 2017

How to create a logon trigger

›
In this particular example, I create a logon trigger that sets one of many available NLS session parameters, as well as sets an undocumentet...
Tuesday, April 4, 2017

How to find the NLS_LENGTH_SEMANTICS used for your PL/SQL objects

›
Use the view DBA_PLSQL_OBJECT_SETTINGS: SELECT OWNER,NAME,TYPE,NLS_LENGTH_SEMANTICS FROM DBA_PLSQL_OBJECT_SETTINGS WHERE OWNER IN ('USE...
Monday, November 21, 2016

How to install and use the character set scanner

›
Although deprecated since the release of DMU (Database Migration utility for Unicode), there are still cases where you need to run csscan. ...
Wednesday, October 5, 2016

Find column semantics

›
When migrating from single-byte code to multi-byte code character sets, one way to move your data without data loss is to change the seman...
Wednesday, August 24, 2016

How to add minutes, seconds, hours or days to a datetime value

›
Simply add the desired interval to your timestamp value: select current_timestamp, current_timestamp + interval '3' minute ...
Wednesday, July 13, 2016

SYSTIMESTAMP and SYSDATE VS. CURRENT_TIMESTAMP and CURRENT_DAY

›
Most DBAs I've spoken to are familiar with the function SYSDATE, but there are some other functions, too, that may prove to be useful, e...
Tuesday, April 5, 2016

MS word characters that have no representation in WE8ISO8859P1 and WE8ISO8859P15

›
During a globalization effort, I found the following interesting information about the difference between the WE8MSWIN1252 and the WE8ISO885...
Wednesday, February 3, 2016

11.2.0.2 and onwards: v$parameter reflects the NLS session parameters, not the NLS instance parameters

›
After a migration of a database from single-byte to multi-byte character set, I wanted to compare the nls_parameters. As a part of the m...
Thursday, October 29, 2015

How to check your Operating System's code page for a particular character

›
I have been involved in several migration projects where we had to deal with Western European characters, which have invalid representation ...
Wednesday, October 28, 2015

How to work around ORA-29275: partial multibyte character when using chr function

›
If you need to check what is actually stored in a database table, meaning the internal representation, you can use the DUMP function. It w...
Monday, October 5, 2015

Is it possible to change the character set of the database by recreating the control file?

›
Question: Is it possible to change the character set of the database by recreating the controlfil? Answer: No, this is not supported. Doc...
Wednesday, July 2, 2014

How to work around ORA-01830: date format picture ends before converting entire input string

›
When querying a column of type TIMESTAMP WITH TIMEZONE, I wanted to omit the fractional seconds + the time zone information. The query ...
Tuesday, June 24, 2014

Where to find the database characterset in the dictionary

›
SQL> select value$ from sys.props$ where name = 'NLS_CHARACTERSET'; VALUE$ ---------------------------------------------------...
Thursday, June 19, 2014

What does the TERRITORY component of the NLS_LANG parameter control?

›
From OTN : "The territory component of the NLS_LANG parameter controls the operation of a subset of globalization support features. ...
Wednesday, June 18, 2014

How to work around ORA-12705 when connecting to your database

›
You get: ERROR: ORA-12705: Cannot access NLS data files or invalid environment specified Solution: Incorrect or misspelled NLS_LANG. F...
Thursday, May 8, 2014

What is the difference between the views nls_database_parameters and nls_instance_parameters?

›
The NLS_DATABASE_PARAMETERS view will display what the NLS settings were when the database was created. These are fixed at the database leve...
Monday, February 10, 2014

Working with TIME ZONE information

›
To view the time zone settings for the database and your session: SELECT DBTIMEZONE, SESSIONTIMEZONE FROM DUAL; DBTIMEZONE SESSION...