Is partitioning of table possible in Oracle 10g Standard edition One??
Printable View
Is partitioning of table possible in Oracle 10g Standard edition One??
Not possible
You could use partition views though ... google for details ;)
Enterprise Edition supports table partitioning.
... as a separately licensed option, of course.Quote:
Originally Posted by PAVB
People,
XE has a limit of 4G! What partitioning? :-)
the question is about standard one, not XE
UPS
My Mistake sorry
Even so, there's nothing about partitioning that makes it only a Big Table solution. Performance is all relative.
In general you want to partition a table either looking to help performance or to help purging strategy.