oracle
关注
分享
扫一扫
oracle数据库
lucas1018
路漫漫其修远兮，吾将上下而求索
展开
-
ORA-14404: partitioned table contains partitions in a different tablespace
通过drop命令删除表空间时若提示：ORA-14404: partitioned table contains partitions in a different tablespace此时只需找出存在于多个表空间的表，然后删除该表即可。假设我这里的表空间是temp_tablespace，先执行以下命令：select x.table_name, x.partition_name, x...原创 2020-03-16 10:24:14 · 667 阅读 · 0 评论 -
ORA-02429: cannot drop index used for enforcement of unique/primary key
通过drop命令删除表空间时若提示：ORA-02429: cannot drop index used for enforcement of unique/primary key此时只需删除主键或唯一性约束的索引即可，方法如下：1.先查看该表空间下所有索引列表//此处假设表空间名为temp_tablespaceselect I.INDEX_NAME, I.INDEX_TYPE...原创 2020-03-15 23:20:58 · 646 阅读 · 0 评论 -
TNS-12555: TNS:permission denied
执行lsnrctl start命令监听时，有时会报如下错误：Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insuff...原创 2020-02-25 16:34:06 · 1523 阅读 · 0 评论 -
CAUSE: The chosen installation conflicted with software already installed in the given Oracle home.
安装oracle时可能会遇到标题中报错情况：[FATAL] [INS-32025] The chosen installation conflicts with software already installed in the given Oracle home. CAUSE: The chosen installation conflicted with software alre...原创 2020-02-25 16:20:40 · 2125 阅读 · 0 评论