[20210418]ORA-14767 Cannot specify this interval with existing high bounds.txt
[20210418]ORA-14767 Cannot specify this interval with existing high bounds.txt
--//連結
--//重複測試:
1.環境:
SCOTT@book> @ ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
CREATE TABLE test(
RUN_DATE DATE,
MY_NBR NUMBER(4)
)
PARTITION BY RANGE (RUN_DATE)
INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION data_p1 VALUES LESS THAN (TO_DATE('01/29/2017', 'MM/DD/YYYY'))
);
*
ERROR at line 1:
ORA-14767: Cannot specify this interval with existing high bounds
--//因為2月份可能沒有29號。執行如下ok。
CREATE TABLE test(
RUN_DATE DATE,
MY_NBR NUMBER(4)
)
PARTITION BY RANGE (RUN_DATE)
INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION data_p1 VALUES LESS THAN (TO_DATE('01/28/2017', 'MM/DD/YYYY'))
);
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2768588/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 提交App中斷出現 Cannot proceed with delivery an existing transporter instanAPP
- ORA-00824:cannot set sga_target due to existing internal setting --SOLUTION
- Mount: you must specify the filesystem type
- How to Specify an INDEX Hint oracle官方文件IndexOracle
- Oracle INTERVAL YEAR TO MONTH 和INTERVAL DAY TO SECOND 資料型別Oracle資料型別
- 2.3.4 Migration of an Existing ApplicationAPP
- 關於interval partitioning
- oracle的interval用法特例Oracle
- Interval資料型別資料型別
- 手工建庫啟動例項時一個小錯誤:ORA-00824: cannot set sga_target due to existing internal settings
- You can‘t specify target table ‘Person‘ for update in FROM clause
- 巧妙設定job的interval
- Interval Partition table 11G
- Leetcode Insert IntervalLeetCode
- DATE型別INTERVAL分割槽型別
- Oracle log_checkpoint_interval和Oracle
- [20210418]開啟多個程式執行.txt
- [20210418]查詢v$檢視問題.txt
- mysql中You can’t specify target table for update in FROM clMySql
- linux 掛載光碟:mount: you must specify the filesystem typeLinux
- oracle interval日期函式的bug!Oracle函式
- 如何實現一個Interval HookHook
- leetcode–57–Insert IntervalLeetCode
- Leetcode-Insert IntervalLeetCode
- 時間型別interval year to month型別
- Merge Interval leetcode javaLeetCodeJava
- Insert Interval leetcode javaLeetCodeJava
- SQL Server小知識:Recovery IntervalSQLServer
- oracle interval日期函式的bugOracle函式
- ORACLE JOB INTERVAL引數設定Oracle
- Entity Framework Code-First(14):From Existing DBFramework
- WM Define Strategy for Addition to Existing Stock(十五。3)
- high wait forAI
- INTERVAL分割槽表鎖分割槽操作
- ORA-04068: existing state of packages has been discardedPackage
- HiSpider(Hitask) is a fast and high performance spider with high speedIDEASTORM
- lowbit 與 highbit
- LeetCode之Insert Interval(Kotlin)LeetCodeKotlin