You are here:

Oracle/How to partition a large table

Advertisement


Question
Hi Madam,

Could you please explain me how to partition a large table into small tables say it's having one million records.

Answer
Hello Seshu,

Please check the following link for more details -

http://www.oracle-base.com/articles/misc/partitioning-an-existing-table-using-ex


You can check your DB version and search in respective section of this link.

Hope this helps.

Regards

Suchitra

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Suchitra Joshi

Expertise

I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience

15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

©2016 About.com. All rights reserved.