No question at this time
DBA Top 10
1 M. Cadot 7400
2 B. Vroman 1700
3 P. Wisse 1300
4 P. Tsongayinwe 1200
5 J. Péran 800
6 J. Schnackenberg 400
7 J. Alcroft 200
7 D. Walgude 200
7 B. M 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48726
Total active users1323
Act. users last 24h0
Act. users last hour0
Registered user hits last week35
Registered user hits last month263
Go up

Interval Partitioning
Next thread: How to SELECT XMLTYPE data with Perl DBD::Oracle?
Prev thread: More Efficient Procedure ?

Message Score Author Date
Hi All, I have created partition table using I...... sathish kumar Aug 18, 2015, 12:46
Of course (for local indexes) and a simple test ...... Michel Cadot Aug 18, 2015, 13:14

Follow up by mail Click here

Subject: Interval Partitioning
Author: sathish kumar, India
Date: Aug 18, 2015, 12:46, 2776 days ago
Oracle info: ANy version
Message: Hi All,

I have created partition table using Interval Partitioning method. So whenever new data trying to insert data whether it will not come under existing partition, New partition created automatically and insert the data.

But in that case, Whether index partition will create automatically ?
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Interval Partitioning
Author: Michel Cadot, France
Date: Aug 18, 2015, 13:14, 2776 days ago
Message:
Of course (for local indexes) and a simple test will confirm it.

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