OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » partition table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

partition table [message #146382]

Thu, 10 November 2005 02:10

deeptimadan
Messages: 17
Registered: October 2005

Junior Member

Hi

We have some tables which are very large and continuously increasing....can i partition the existing tables in 8i...as i have seen only create command..

regards

Report message to a moderator

Re: partition table [message #146445 is a reply to message #146382]

Thu, 10 November 2005 08:29

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

To my knowledge, you are stuck with creating new versions of your tables that are partitioned, and then moving the data from the old tables to the new.

Report message to a moderator

Re: partition table [message #146537 is a reply to message #146382]

Thu, 10 November 2005 23:13

deeptimadan
Messages: 17
Registered: October 2005

Junior Member

Hi
No, My table are not parttioned..I want to partition them ..Is it possible to partition existing tables as i have read that by partitioning you can have better performance ..besides that table are too large to be analyzed ..that means it takes lot of time ...
as i have seen only create table command in partitioning..i wanted to ask is partition possible in existing tables and how..

Deepti madan

Report message to a moderator

Re: partition table [message #146841 is a reply to message #146537]

Mon, 14 November 2005 03:17

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

Various ways to partition an existing table are:

* Creating the partitioned table from scratch, using CREATE TABLE ... AS SELECT to select from the original table
* Creating the table, then populating it from the original table using INSERT /*+ APPEND */
* Using EXPORT to extract data from the table, dropping and recreating it partitioned and then IMPORTing back in to it
* export the table's data to a flat file, drop and recreate it with partitions, then use SQL*Loader direct path

I hope this helps.

--Source:
http://dba-oracle.com/oracle_news/2004_3_9_rittman.htm

--Girish

Report message to a moderator