Data Blog

Oracle Database 12c’s Online Data Reorganization & Redefinition Tool

With the Online Data Reorganization & Redefinition feature, you can redefine your tables while it is online.

Because you rely on e-commerce for a significant part of your income, you really need to make sure that your systems are available 24 hours a day, 7 days a week.  The cost of application downtime is staggeringly high, not only do you lose sales, but your reputation takes a hit as well.  Gartner Group estimates that enterprises lose millions of dollars for every hour that they are offline.  And for this reason, enterprises need to make sure that their databases are always available and easily manageable.

One way to ensure both is to give users full access to your database even during a data reorganization, and this is where Oracle helps.

Oracle Database 12c has the Online Data Reorganization & Redefinition feature, which gives you the ability to change physical attributes of your tables and transform table and data structure without taking your database offline.  What all these lead to is better data availability, faster query performance and response time, as well as optimized used of disk space.  Ultimately, these would help you make application upgrade a much faster, safer and easier process.

With the Online Data Reorganization & Redefinition feature, you can redefine your tables while it is online.  This means that the table being changed is accessible by write and read operations.  Database and system administrators could start the redefinition process and then they can synchronize the interim table in order for it to include the changes made to the original table.  What’s more, it is possible to use the data or validate it while it is undergoing redefinition.  This helps you make sure that the upgrade process runs without a hitch.  Your administrators will have the final say when to switch over to the newly modified table from the original table.  This switching process takes a very short time and is not affected by the size of your table or no matter how intricate your redefinition is.

After your redefinition, what you get is an entirely new table with improved efficiency in its data block layout.

You can use the Online Data Reorganization & Redefinition feature via the Oracle Enterprise Manager.  Or you could also use it using the SQL Plus command line interface.

There are two ways to do it, depending on the type of reorganization you want to carry out.  One is to use DBMS_REDEFINITION, or you could also use SQL CREATE/ALTER TABLE and INDEX commands.

If you want to be able to reorganize your data or redefine your table without needing to take your database offline while still ensuring that your users get access to the latest data and information, then you should definitely consider using the Online Data Reorganization & Redefinition feature in Oracle Database 12c. Four Cornerstone has Oracle consulting services that put you in touch with a team of Oracle experts who have decades of experience working for a variety of companies belonging to different industries.  These Oracle certified experts help you avoid the guesswork.  Even if you have been using Oracle Database 11g, you will still need to learn what’s new with Online Data Reorganization & Redefinition in Oracle Database 12c.

Contact Four Cornerstone today!

Photo by Oracle.

Uncategorized

Performance Boost in MySQL 8.0.35…

Oracle has recently published interesting performance numbers that show MySQL 8.0.35 Enterprise Edition about 25%, or higher, faster than MySQL Community Edition.   A great...

Keep Reading

Uncategorized

Security Trends For 2024: SBOMs

A recent article on Forbes, linked below, lists five security trends that are likely to be important in 2024. Of course, AI-related security topics top...

Keep Reading

Uncategorized

Getting started with your first…

Anyone looking at writing their first Generative AI application should read this to save time. In June 2023, Google Cloud published a useful blog post,...

Keep Reading

Uncategorized

Read-Write and Read-Only query splitting…

Optimize the usage of the standby (secondary) read-only MySQL InnoDB Cluster servers by automatically and transparently distributing read-queries to them. A great feature in MySQL...

Keep Reading

Uncategorized

Considering Cloud Diversification?

Moving an enterprise to a Public Cloud can quickly feel like moving into a locked-in relationship with the Cloud vendor. One solution to diminish this...

Keep Reading

Uncategorized

Gartner: Global cloud consumption will…

Gartner forecasts that 2024 will see a 20% global cloud consumption increase from 2023 to $679B, while 2023 has seen an 18% increase from 2022...

Keep Reading

Uncategorized

ByteDance: Use AI for tuning…

ZDNet is reporting that a ByteDance (the maker of TikTok) Linux kernel developer has proposed to implement AI to tune the performance of Linux systems...

Keep Reading

AI Governance

What is AI TRiSM?

If reading now about AI TRiSM for the first time, it might be good read on and learn what it’s about because it leads the...

Keep Reading

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Live Chat | Emergency