No question at this time
DBA Top 10
1 A. Kavsek 8600
2 M. Cadot 7000
3 B. Vroman 6000
4 T. Boles 4550
5 J. Schnackenberg 4100
6 P. Wisse 3000
7 T. P 1200
8 G. Lambregts 1100
8 . Lauri 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48373
Total active users1542
Act. users last 24h9
Act. users last hour0
Registered user hits last week188
Registered user hits last month1051
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, 84 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, 84 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, 84 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