ORA-14606: Tablespace was specified for previous subpartitions in template but is not specified for string ORACLE 报错 故障修复 远程处理
文档解释
ORA-14606: Tablespace was specified for previous subpartitions in template but is not specified for string
Cause: Tablespaces may either be specified for all subpartitions or must not be specified for any subpartitions
Action: Either specify tablespaces for all or for none of the subpartitions
这是一个ORACLE数据库的错误信息,它表明您尝试在模板中为某一附件子分区( Subpartitions )指定表空间,但遗漏在另一附件子分区中指定了该表空间。
ORA-14606发生,当使用CREATE TABLE SUBPARTITION TEMPLATE子句构建子分区模板时,Oracle检查显式地指定了前一个子分区的表空间,但没有在该模板中其他子分区引用相同的表空间时。
例如,下面显示在使用模板创建分区表时可能会发生ORA-14606错误的情况:
CREATE TABLE SALES_HISTORY
( other columns)
PARTITION BY RANGE (SALE_DATE)
SUBPARTITION BY LIST (SALE_LOCATION)
SUBPARTITION TEMPLATE
(SUBPARTITION SALES_EAST_01 VALUES ( EAST ) TABLESPACE TS_EAST,
SUBPARTITION SALES_WEST_01 VALUES ( WEST ) );
正常处理方法及步骤1、修改语句,将相同的表空间指定给后续子分区,避免出现ORA-14606错误:
CREATE TABLE SALES_HISTORY
( other columns)
PARTITION BY RANGE (SALE_DATE)
SUBPARTITION BY LIST (SALE_LOCATION)
SUBPARTITION TEMPLATE
(SUBPARTITION SALES_EAST_01 VALUES ( EAST ) TABLESPACE TS_EAST,
SUBPARTITION SALES_WEST_01 VALUES ( WEST ) TABLESPACE TS_EAST );
2、其他处理可以使用NO TABLESPACE子句替换TABLESPACE子句,这样可以避免ORA-14606错误:
CREATE TABLE SALES_HISTORY
( other columns)
PARTITION BY RANGE (SALE_DATE)
SUBPARTITION BY LIST (SALE_LOCATION)
SUBPARTITION TEMPLATE
(SUBPARTITION SALES_EAST_01 VALUES ( EAST ) TABLESPACE TS_EAST,
SUBPARTITION SALES_WEST_01 VALUES ( WEST ) NO TABLESPACE );
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 ORA-14606: Tablespace was specified for previous subpartitions in template but is not specified for string ORACLE 报错 故障修复 远程处理
相关文章
- ORA-21701: attempt to flush objects to different servers ORACLE 报错 故障修复 远程处理
- ORA-26737: version string already has an export dump file ORACLE 报错 故障修复 远程处理
- ORA-29843: indextype should support atleast one operator ORACLE 报错 故障修复 远程处理
- ORA-29953: cannot issue DDL on a domain index partition marked as FAILED ORACLE 报错 故障修复 远程处理
- ORA-48242: Fields that are NOT NULL can not use surrogates ORACLE 报错 故障修复 远程处理
- ORA-55569: The UNDO_RETENTION parameter value should be atmost string, the _highthreshold_undoretention setting. ORACLE 报错 故障修复 远程处理
- ORA-01639: instance string has no thread assigned to it ORACLE 报错 故障修复 远程处理
- ORA-01881: timezone region ID is invalid ORACLE 报错 故障修复 远程处理
- ORA-02180: invalid option for CREATE TABLESPACE ORACLE 报错 故障修复 远程处理
- ORA-03238: unable to extend LOB segment string.string subpartition string by string in tablespace string ORACLE 报错 故障修复 远程处理
- ORA-07534: scginq: $getlki unexpected return on lockid string ORACLE 报错 故障修复 远程处理
- ORA-09843: soacon: Archmon unable to create named pipe. ORACLE 报错 故障修复 远程处理
- ORA-09883: Two Task interface: oratab file does not exist ORACLE 报错 故障修复 远程处理
- ORA-09890: osnTXtt: malloc failed ORACLE 报错 故障修复 远程处理
- ORA-12733: regular expression too long ORACLE 报错 故障修复 远程处理
- ORA-16095: Dependent destination removal for inactivation ORACLE 报错 故障修复 远程处理
- ORA-16425: RECOVER FINISH cannot be issued when recovery branch string is not the target branch string. ORACLE 报错 故障修复 远程处理
- ORA-16727: cannot close database ORACLE 报错 故障修复 远程处理
- ORA-19186: FOCA0001: input value too large for decimal ORACLE 报错 故障修复 远程处理
- 增删改简易指南:Oracle SQL增删改查(oracle修改sql)
- 探究Oracle系统端口号之秘密(查看oracle端口号)
- Oracle表未设定主键情况下的解决方案(oracle表没有主键)
- Oracle触发器:类型考察(oracle触发器类型)
- 编程最先进的Oracle存储过程并行编程技术(oracle存储过程并行)
- 处理解决Oracle报错日志的方法(oracle报错日志)
- Oracle 数据被删除警示,备份救命!(oracle数据被删除)
- Oracle函数Ceil让数据可以更高精度取整(oracle函数ceil)
- 空间Oracle表空间的数量有多少(oracle 共有几个表)
- Oracle依赖路径解析找出更优解(oracle依赖路径)
- Oracle中如何使用浮点类型进行精确的数值计算(oracle中浮点类型)
- Oracle创建用户的困境被禁止(oracle不能创建用户)