• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

Online reorganisation of tables using Dbms_redefination

Online table redefinition using DBMS_REDEFINITION

December 18, 2015 by techgoeasy Leave a Comment

We often need to perform reorganization of the tables . We have to do offline by taking system down and it consumes lot of time.we can perform an Online table redefinition using DBMS_REDEFINITION. This feature is available from 9i. How Oracle internally achieve this Online table redefinitionTo achieve this online reorganization, incrementally maintainable local materialized […]

Filed Under: Oracle, Oracle Database Tagged With: Online reorganisation of tables using Dbms_redefination

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to check Stale statistics
  • Java web start(JWS) in R12
  • How to delete the archive logs in Oracle
  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us