Questions about the Oracle automatic partition, the date of the numeric types, the interval is how t-CodePudding

Home > database > Questions about the Oracle automatic partition, the date of the numeric types, the interval is how t

Questions about the Oracle automatic partition, the date of the numeric types, the interval is how t

Time：09-21

For a great god, existing a table, field to NY (number (6)), a data item format for 201401201 402201 403...
Now want to create partitions automatically, achieve 201401 a partition, a partition, 201402 201403 a partition, the partition of the interval is how to write?
PARTITION BY RANGE (NY) interval (?)

CodePudding user response:

Has been resolved, it is the interval (1), can be solved

CodePudding user response:

The date format? In December, pay attention to avoid,

Page link：https//www.codepudding.com/database/18336.html

Prev:Oracle database Chinese garbled JDBC connection

Next:Everyone a great god have what good method can make two same database import and export of a part of

Tags：

The development of

Links：
CodePudding