Thanks Mike, I can confirm this works.
For reference, if anyone is using ORM, you can provide the `info` as an
attribute to `__table_args__`, like:
class Foo(Base):
__tablename__ = 'foo'
name = Column(String(10), primary_key=True)
__table_args__ = {
'info': {
Here is a recipe using compilation extension
(http://docs.sqlalchemy.org/en/rel_1_1/core/compiler.html):
"""
CREATE TABLE sales_hash
(s_productid NUMBER,
s_saledate DATE,
s_custid NUMBER,
s_totalprice NUMBER)
PARTITION BY HASH(s_productid)
( PARTITION p1 TABLESPACE tbs1
,
Hello,
In Oracle we can create a Partitioned Table like the following:
CREATE TABLE sales_hash
(s_productid NUMBER,
s_saledate DATE,
s_custid NUMBER,
s_totalprice NUMBER)
PARTITION BY HASH(s_productid)
( PARTITION p1 TABLESPACE tbs1
, PARTITION p2 TABLESPACE tbs2
, PARTITION p3