Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

partition table

Posted on 2011-03-10
1
Medium Priority
?
260 Views
Last Modified: 2012-05-11
I am looking to speed up full table scans by partitioning a table. Do a first create the partition table, then bring the data in and then drop the old table?
0
Comment
Question by:msimons4
1 Comment
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 35096469
>>I am looking to speed up full table scans by partitioning a table.

I assume you've already done your homework and have verified this will speed up the system as a whole?



There are a lot of links out there on how to partition an existing table.  The exact method you use should be based on what makes sense in your specific system.


Partitioning an Existing Table using DBMS_REDEFINITION
http://www.oracle-base.com/articles/misc/PartitioningAnExistingTable.php

Partitioning an Existing Table using EXCHANGE PARTITION
http://www.oracle-base.com/articles/misc/PartitioningAnExistingTableUsingExchangePartition.php

There are more if you Google around a little.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question