Home » RDBMS Server » Performance Tuning » Converting Non-Partitioned table to Partition table
Converting Non-Partitioned table to Partition table [message #196782] Sat, 07 October 2006 05:25 Go to next message
Messages: 282
Registered: March 2005
Location: Bangalore
Senior Member

Hi Experts,
Is there a direct way to change a non-partitioned table to a partition one?

We have one problem, currently in production in which a table (non-partitioned) in which many concurrent INSERT requests happen through WINDOWS service and sometimes the ENQUEUE wait are too high. What we are planning is to HASH partition the table. Is there any way where we can directly create partitions in the table?

The option we are looking at is:

1. Create an empty HASH partitioned table.
2. Transfer the records from existing table to new partitioned table and then drop the old one and rename it.

Is there a better way to do this? As we have 4,00,000 records in table and pushing in to temp table might take some time and result in more downtime.

Also, how can I find out how many CONCURRENT INSERT request are happening on any given table?

Re: Converting Non-Partitioned table to Partition table [message #196801 is a reply to message #196782] Sat, 07 October 2006 10:49 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Yes u can do that/

just go through below link
before doing this u have come checking on ur tables.

go database fundametal section. in above link
Previous Topic: Regarding I/O Performance
Next Topic: dbms_session.set_sql_trace_in_session('12,25')
Goto Forum:

Current Time: Tue Apr 25 21:19:25 CDT 2017

Total time taken to generate the page: 0.05723 seconds