oracle 取消 interval分区,关于ORACLE11g的interval分区

SQL>select * from topsi_bbc partition (part_201210) where rownum <= 10;

CGENERALBBCID        CGENERALBID          VBARCODE

-------------------- -------------------- --------------------------------------------------------------------------

DBIZDATE       DEPARTMENTID CHANNEL    STORETYPE                                TACCOUNTTIME

---------- ---------------- ---------- ---------------------------------------- ------------------------------------

ZINERFVVSIDSYARJEYVI 1001V610000000C1MWWH 354579052279739

,,,

WNBLQCQJJCTYFVDEUFDJ 1001V610000000C1MWWH 354579052316523

10 rows selected.

Elapsed: 00:00:00.26

SQL>select * from topsi_bbc partition for (to_date('2012-10-03','yyyy-mm-dd')) where rownum <= 10;

select * from topsi_bbc partition for (to_date('2012-10-03','yyyy-mm-dd')) where rownum <= 10

*

ERROR at line 1:

ORA-00905: missing keyword

Elapsed: 00:00:00.01

SQL>select sysdate from dual;

SYSDATE

-------------------

2012-11-04 20:33:17

Elapsed: 00:00:00.01

SQL>select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

PL/SQL Release 10.2.0.5.0 - Production

CORE    10.2.0.5.0      Production

TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio

NLSRTL Version 10.2.0.5.0 - Production

5 rows selected.

Elapsed: 00:00:00.01