CODEWITHSUNDEEP
oracle11goracle10g
Dharmesh Porwal
Dharmesh Porwal

Reputation: 1406

Autonomous Partitioning of Table in Oracle?

Is it possible to make Autonomous Partitioning of a table in Oracle ?

I want the new partition get created automatically on exceeding the range or limit assign to it. Suppose I partitioned a table on the basis of year and I want as soon as the new year begin the new partition must be created automatically, means I don't have to create it manually.

Upvotes: 0

Views: 86

Answers (1)

Justin Cave
Justin Cave

Reputation: 231671

It depends on the Oracle version you're using. You've tagged this for both 10g and 11g and the answer is different between the two.

In 11g, you can use interval partitioning to have Oracle automatically create new partitions when new data is inserted. Prior to that, you'd need to explicitly create the partitions you need. You could always, of course, allow new rows to be inserted into one partition with a very large MAXVALUE and then split the partition later on but I assume that's not exactly what you're looking for.

If you're partitioning on a date, you could also create a scheduled job that created partitions just before they are needed. If you really wanted to, you could also create hundreds of partitions in advance.

Upvotes: 1

Related Questions