Skip to Main Content
  • Questions
  • Best method to re-org Very Big Banking Tables

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Hariharan.

Asked: March 11, 2018 - 8:59 am UTC

Last updated: March 13, 2018 - 11:39 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hello All,

We need expert advice how can we achieve the ONLINE table reorganization and data files shirking. this is a core banking database of one of the biggest bank.

i can provide all required information from my side, if you are ready to analyze and provide me the best solution to achieve this activity.

i have read some document but its not 100% online, there is some downtime required and data file shrink options are not appropriate.

How can i achive this Re-org for Very Big Tables Online.



Thanks in Advance.



and Connor said...

In 11.2, your best way is via DBMS_REDEFINITION. This is as close to online as you can get with 11.2

In 12.2, online table move, plus heaps of other facilities are available to you.

Here's a video I did demonstrating the 12.2 features - it's a little bit of fun, but it also showcases just how flexible we've made online operations in 12.2


Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Hariharan Senthil pandiyan, March 12, 2018 - 1:01 pm UTC

Thanks for the update ,

Is there any option you can suggest us to go Completely Online for these Banking Tables ( these are Very Big Tables ).

Thank,
Connor McDonald
March 13, 2018 - 2:12 am UTC

DBMS_REDEFINITION is online for the entire process except for perhaps 5-10 seconds at the end of the process.

A reader, March 13, 2018 - 5:37 am UTC

Thanks for your confirmation . We can close the call now.
Connor McDonald
March 13, 2018 - 11:39 am UTC

glad we could help

Hariharan Senthil pandiyan, May 03, 2018 - 7:33 am UTC

Thanks You,

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database