CODEWITHSUNDEEP
oracle-database
sumit vedi
sumit vedi

Reputation: 119

Create a partition in the table

I want to create a table in which data is store in partition as well as sub-partition.

Suppose I want to insert the data under the partition (P_name) of the table. If partition is already exist then insert the data under this partition otherwise create the partition and then insert the data.

Can you please help me on the same problem for sub-partition.

Thanks in advance.

Upvotes: 0

Views: 183

Answers (1)

David Aldridge
David Aldridge

Reputation: 52336

Automatic creation of partitions is supported for interval partitioning only, as of 11.2.

Also, you should generally avoid inserting into particular named partitions.

Upvotes: 1

Related Questions