:

RSSPartitioning

ORA-14160: this physical attribute may not be specified for a table subpartition

The ORA-14160 this physical attribute may not be specified for a table subpartition erro occurred when I forgot to add the comma and the end of each subpartition specification. 9 times out of 10 this error will be the result of a typo or incorrectly specified table definition. In the example below, commas should be […]

Continue Reading

ORA-14099: all rows in table do not qualify for specified partition

We have a table within our DB which stores every transaction which is made within our application. As you can imagine, this table is heavily updated and we create around 10,000,000 rows everyday on our Production system. Further to this, we are required to save this data for 2 weeks just in case we need […]

Continue Reading