![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 595 阅读 · 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_tablespace select I.INDEX_NAME, I.INDEX_TYPE...原创 2020-03-15 23:20:58 · 535 阅读 · 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 · 1411 阅读 · 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 · 1962 阅读 · 0 评论