Although “Big data” is one of the most used Buzz words of the days in the IT industry, it makes sense to understand the reason why it is one of the hottest technologies of the day and why managing big data continues to be one of the biggest challenges faced by most folks in the IT industry. Data itself has been the pivotal point of technology for many years as it is information in its most raw form and there have been many different approaches to storing and retrieving data most efficiently and in a fast manner. These challenges are being summarized into what is called the three V’s of Big Data.
The NLS_CHARACTERSET of an Oracle database defines what characters can be stored in the database using the CHAR, VARCHAR2, LONG and CLOB datatypes. This blog gives a quick overview of a method to change the database character set or to check before migrating data between databases with a different NLS_CHARACTERSET.
If you change character sets there is a possibility that characters that you currently use are not defined in the new character set or that the current setup is not correctly used and therefore you could lose data when changing the NLS_CHARACTERSET.
In previous blog “2014-06 – Database Character Set Scanner”, we addressed how to install a great Oracle tool called CSSCAN. Always check data migration by using the Character Set Scanner (CSSCAN) before making any changes to your character set.
With every new version, Oracle introduces exciting features like Oracle Multitenant option, Oracle Active Data Guard Far Sync, information lifecycle management enhancements and new data types just to name a few. Customers wishing to take advantage of these and other new features will need to upgrade their existing databases, as well as migrate onto modern infrastructure to ensure high levels of performance.
It’s official! VLSS is proud to announce that it is the first and only Pure Storage certified implementation partner for Oracle database!
VLSS has been a premier Oracle consulting firm since it’s founding in 2005, with Oracle Certified Masters on staff and experts with decades of experience in database migrations, upgrades, Real Application Clusters, Data Guard, performance tuning and optimization.
Designing and setting up a new database system can take a lot of planning. But typically, one important decision is overlooked: choosing the right character set. A basic consideration for choosing a character set is to make sure it can handle any language that needs to be supported immediately and in the future. Oracle has documentation on the capabilities and performance implications of different character sets (Choosing a Character Set). Sometimes you have to change the database character set to support a new application.