Advertisement
ExaGridDba

interval partitioned IOT not supported in 12.1.0.2

May 9th, 2015
347
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. > DROP TABLE iotrange
  2. TABLE IOTRANGE dropped.
  3. > CREATE TABLE iotrange
  4. (
  5. d DATE,
  6. n NUMBER,
  7. CONSTRAINT iotrange_pk PRIMARY KEY ( d,n )
  8. )
  9. ORGANIZATION INDEX
  10. PARTITION BY RANGE ( d )
  11. (
  12. PARTITION p2014 VALUES less than (TO_DATE('2015-01-01','yyyy-mm-dd'))
  13. )
  14. TABLE IOTRANGE created.
  15. > DROP TABLE heapinterval
  16. TABLE HEAPINTERVAL dropped.
  17. > CREATE TABLE heapinterval
  18. (
  19. d DATE,
  20. n NUMBER,
  21. CONSTRAINT heapinterval_pk PRIMARY KEY ( d,n )
  22. )
  23. PARTITION BY RANGE ( d ) INTERVAL (INTERVAL '1' DAY)
  24. (
  25. PARTITION p2014 VALUES less than (TO_DATE('2015-01-01','yyyy-mm-dd'))
  26. )
  27. TABLE HEAPINTERVAL created.
  28. > CREATE TABLE iotinterval
  29. (
  30. d DATE,
  31. n NUMBER,
  32. CONSTRAINT iotinterval_pk PRIMARY KEY ( d,n )
  33. )
  34. ORGANIZATION INDEX
  35. PARTITION BY RANGE ( d ) INTERVAL (INTERVAL '1' DAY)
  36. (
  37. PARTITION p2014 VALUES less than (TO_DATE('2015-01-01','yyyy-mm-dd'))
  38. )
  39.  
  40. Error starting AT line 29 IN command:
  41. CREATE TABLE iotinterval
  42. (
  43. d DATE,
  44. n NUMBER,
  45. CONSTRAINT iotinterval_pk PRIMARY KEY ( d,n )
  46. )
  47. ORGANIZATION INDEX
  48. PARTITION BY RANGE ( d ) INTERVAL (INTERVAL '1' DAY)
  49. (
  50. PARTITION p2014 VALUES less than (TO_DATE('2015-01-01','yyyy-mm-dd'))
  51. )
  52. Error AT Command Line:37 COLUMN:1
  53. Error report:
  54. SQL Error: ORA-25198: only RANGE, list, AND hash partitioning are supported FOR index-organized TABLE
  55. 25198. 00000 -  "only range, list, and hash partitioning are supported for index-organized table"
  56. *Cause:    SYSTEM, OR Composite partitioning schemes are NOT supported yet
  57. *Action:   SELECT a different partitioning scheme
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement