No question at this time
DBA Top 10
1 M. Cadot 9900
2 B. Vroman 9200
3 A. Kavsek 7500
4 T. Boles 6250
5 J. Schnackenberg 5100
6 P. Wisse 2700
7 M. Hidayathullah ... 1500
8 T. P 1200
9 G. Lambregts 1100
9 . Lauri 1100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48352
Total active users1553
Act. users last 24h3
Act. users last hour0
Registered user hits last week285
Registered user hits last month926
Go up

Need Advise on Partition Maintenance
Next thread: Synonym ALL_GSPACE
Prev thread: ORA-12547: TNS:lost contact Error when try to connect using sysdba

Message Score Author Date
Hi, I have some range partitioned tables that h...... BenBart BartBen Feb 26, 2019, 12:14
Hi BB, If you want to keep the data you might k...... Philip Wisse Feb 26, 2019, 12:57
Hi BenBart, You wrote: I am hoping to decrease ...... Lauri Feb 26, 2019, 14:17

Follow up by mail Click here


Subject: Need Advise on Partition Maintenance
Author: BenBart BartBen, Philippines
Date: Feb 26, 2019, 12:14, 25 days ago
Os info: Solaris
Oracle info: Oracle8
Message: Hi,

I have some range partitioned tables that has about 200+ partitions. The database is an OLTP database.

I need some advise on how to trim these partitioned tables or maybe there is a 'general' rule of some sort in so far as partition maintenance is concern.

I am hoping to decrease the number of partitions down to the last 2 years = 24 partition. Do I just create separate 200+-24 small tables and do an exchange partition and keep the last 24 partitions?

Please advise if there is some link that link/doc that I can refer to for review. Thanks in advance.

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Need Advise on Partition Maintenance
Author: Philip Wisse, Netherlands
Date: Feb 26, 2019, 12:57, 25 days ago
Message: Hi BB,

If you want to keep the data you might keep it in the partitioned table.

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Need Advise on Partition Maintenance
Author: Lauri, Netherlands
Date: Feb 26, 2019, 14:17, 25 days ago
Message: Hi BenBart,

You wrote: I am hoping to decrease the number of partitions down to the last 2 years = 24 partition. Do I just create separate 200+-24 small tables and do an exchange partition and keep the last 24 partitions?
I think the first step is to have your data up to the last 2 years. So, I guess you will do some cleansing right?
If so, then let the partitions are they are (200+).
At a later stage, you can consider merging some partitions.

Kind Regards,

Lauri
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here