6 Replies Latest reply: Jan 23, 2013 4:21 AM by 986109 RSS

    Oracle Tables Partitioning

      I am planning for table partitioning of existing tables...

      database is production 10gR1 i need it to upgrade to 11gR2 and also implement table partitioning. what should be the best way to do so with minimum downtime and zero data loss. Please advice. size of the tables are 20 to 40GB.. source database is in solaris and planning to migrate on linux.
        • 1. Re: Oracle Tables Partitioning
          So is your question about partitioning or upgrading?

          If upgrading...

          • 2. Re: Oracle Tables Partitioning
            my question is for partitioning with minimum downtime with zero data loss.
            the scenario is like
            I took a export of source table and create a new partitioned table with different name, then import the data into new table, drop the source table and rename the new partitioned table with the source tables's name. Its all fine because there will be very minimum downtime but here we will loss some data. It is because the transactions which are done in the mean time will not be in the exported file. Is there any way another..? I hope you got my question.
            • 3. Re: Oracle Tables Partitioning
              Take a look at the DBMS_REDEFINITION package.

              • 4. Re: Oracle Tables Partitioning
                Hemant K Chitale
                You can't be using DBMS_REDIFINITION if you want to run both the Upgrade and the table Partitioning (i.e. DBMS_REDEFINITION cannot be used across the upgrade).

                You should split these as two separate actions. I would recommend an Upgrade first followed by implementation of Partitioning later.

                You must test your Partitioning design in a test environment to see that it meets performance (query and DML) requirements and data maintenance requirements.

                Hemant K Chitale

                Edited by: Hemant K Chitale on Jan 22, 2013 3:04 PM
                • 5. Re: Oracle Tables Partitioning
                  Please read

                  • 6. Re: Oracle Tables Partitioning
                    thanks for the suggestions..i will try partition exchange. thanks a lot.