Hi! All,
I have a table whoose structure is
*COMPANYID NOT NULL NUMBER(20)
*FINANCIALYEAR NOT NULL NUMBER(4)
*TLSDATAPOINTCODE NOT NULL VARCHAR2(20)
QUARTER NUMBER(2)
NUMBERVALUE NUMBER(20,5)
STRINGVALUE VARCHAR2(4000)
DATEVALUE DATE
BOOLEANVALUE NUMBER(1)
CREATEDBY NUMBER
CREATEDDATE DATE
MODIFIEDBY NUMBER
MODIFIEDDATE DATE
MANUALMODIFICATIONFLAG NUMBER(1)
*- PK
The table has 7005892 rows in it currently and it is going to triple in comming 3 months.
I want to partition the table on Financialyear.
1) Can I partition the table with data?
2) What are the pros and cons of partitioning on financialyear which not the left most column of the PK
There Nothing You cannot Do, The problem is HOW.