Поможите с партицией

Error starting at line 1 in command:

CREATE TABLE "FLOW"."AGGREGAT"
( "ID_ROUTE" NUMBER(*,0) NOT NULL ENABLE,
"STAMP" TIMESTAMP WITH TIME ZONE (6) NOT NULL ENABLE,
"OCTETS" NUMBER NOT NULL ENABLE,
"FLOW_TIME" NUMBER(*,0) NOT NULL ENABLE,
CONSTRAINT "AGGREGAT_PK" PRIMARY KEY ("ID_ROUTE", "STAMP") ENABLE,
CONSTRAINT "AGGREGAT_ROUTE_FK" FOREIGN KEY ("ID_ROUTE")
REFERENCES "FLOW"."ROUTE" ("ID_ROUTE") ENABLE
)
PARTITION BY RANGE ("STAMP")
(PARTITION "march_07" VALUES LESS THAN
( TO_TIMESTAMP('01-03-07 00:00:00.000000', 'DD-MM-RR HH24:MI:SS.FF') ) nocompress)

Error report:
SQL Error: ORA-00907: отсутствует правая скобка

Тебе не кажется, что при объявлении таймштампа вначале нужно указывать точность, а лишь затем WITH TIME ZONE, а не наоборот...
Вот так попробуй:

CREATE TABLE "FLOW"."AGGREGAT" 
  (
    "ID_ROUTE" NUMBER(10,0) NOT NULL ENABLE, 
    "STAMP" TIMESTAMP(6) WITH TIME ZONE  NOT NULL ENABLE, 
    "OCTETS" NUMBER NOT NULL ENABLE, 
    "FLOW_TIME" NUMBER(10,0) NOT NULL ENABLE, 
    CONSTRAINT "AGGREGAT_PK" PRIMARY KEY ("ID_ROUTE", "STAMP") ENABLE, 
    CONSTRAINT "AGGREGAT_ROUTE_FK" FOREIGN KEY ("ID_ROUTE") REFERENCES "FLOW"."ROUTE" ("ID_ROUTE") ENABLE
  )
PARTITION BY RANGE ("STAMP")
  (
    PARTITION "march_07" VALUES LESS THAN ( TO_TIMESTAMP('01-03-07 00:00:00.000000', 'DD-MM-RR HH24:MI:SS.FF') ) 
    nocompress
  )

TIMESTAMP (6) WITH TIME ZONE

Спасибо, но ...
Error report:
SQL Error: ORA-03001: средство не реализовано

SEugene

Спасибо, но ... Error report: SQL Error: ORA-03001: средство не реализовано

Версия сервера какая?
Из какой инструментальной среды патаешься выполнить создание таблицы?

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
Юзаю Oracle SQL Developer 1.0.0.14

А документацию почитать?
Restriction on Partitioning Key Columns. The columns in the column list can be of any built-in datatype except ROWID, LONG, LOB, or TIMESTAMP WITH TIME ZONE.

Grei

А документацию почитать? Restriction on Partitioning Key Columns. The columns in the column list can be of any built-in datatype except ROWID, LONG, LOB, or TIMESTAMP WITH TIME ZONE.

Более того, если даже поменять тип поля на DATE, то форматная маска с RR не поканает:

Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02

Note: If table is partitioned on a DATE column, and if the date format does not specify the first two digits of the year, then you must use the TO_DATE function with the YYYY 4-character format mask for the year. (The RRRR format mask is not supported.) The date format is determined implicitly by NLS_TERRITORY or explicitly by NLS_DATE_FORMAT

Если партица по Timestamp:

CREATE TABLE "FLOW"."AGGREGAT"
( "ID_ROUTE" NUMBER(*,0) NOT NULL ENABLE,
"STAMP" TIMESTAMP(6) NOT NULL ENABLE,
"OCTETS" NUMBER NOT NULL ENABLE,
"FLOW_TIME" NUMBER(*,0) NOT NULL ENABLE,
CONSTRAINT "AGGREGAT_PK" PRIMARY KEY ("ID_ROUTE", "STAMP") ENABLE,
CONSTRAINT "AGGREGAT_ROUTE_FK" FOREIGN KEY ("ID_ROUTE")
REFERENCES "FLOW"."ROUTE" ("ID_ROUTE") ENABLE
)
PARTITION BY RANGE ("STAMP")
(
PARTITION "march_07" VALUES LESS
THAN ( TO_TIMESTAMP('01-03-07 00:00:00.000000', 'DD-MM-RR HH24:MI:SS.FF') )
nocompress
)

Error report:
SQL Error: ORA-30078: граница секции должна образовываться литералами TIME/TIMESTAMP WITH TIME ZONE

Спасибо за ответы, я сам разобрался :))

CREATE TABLE "FLOW"."AGGREGAT"
( "ID_ROUTE" NUMBER(*,0) NOT NULL ENABLE,
"STAMP" timestamp NOT NULL ENABLE,
"OCTETS" NUMBER NOT NULL ENABLE,
"FLOW_TIME" NUMBER(*,0) NOT NULL ENABLE,
CONSTRAINT "AGGREGAT_ROUTE_FK" FOREIGN KEY ("ID_ROUTE")
REFERENCES "FLOW"."ROUTE" ("ID_ROUTE") ENABLE
)
PARTITION BY RANGE ("STAMP")
(
PARTITION "march_07" VALUES LESS
THAN ( TO_date('01-03-2007', 'DD-MM-YYYY') )
nocompress
);