Oracle9i 建一个新的DB 时出现ORA-29807 & ORA-01430 解决方法

最新推荐文章于 2024-01-11 14:47:30 发布

最新推荐文章于 2024-01-11 14:47:30 发布 · 3k 阅读

文章标签：

#Oracle #SQL

Oracle错误集专栏收录该内容

10 篇文章

订阅专栏

本文介绍了Oracle数据库创建过程中出现的ORA-29807错误及其解决方法。该错误源于Oracle的一个已知Bug，可通过点击忽略继续安装，并在安装完成后运行特定脚本来修复此问题。

ORA-29807: specified operator does not exist
在建立新的DB时会出现的错误。

   这是Oracle 的bug , 可以忽略掉，安装完成后，在$ORACLE_HOME/rdbms/admin 目录下运
行utlrp.sql ，用于修补ORA-29807 错误。

   解释
   ORA-29807: specified operator does not exist
This is a known issue (bug 2925665). You can click on the "Ignore" button to continue.
Once DBCA has completed database creation, remember to run the 'prvtxml.plb' scrīpt
from $ORACLE_HOME/rdbms/admin independently, as the user SYS. It is also advised
to run the 'utlrp.sql' scrīpt to ensure that there are no invalid objects in the database at this time.

Oracle/PLSQL: ORA-01430 Error

--------------------------------------------------------------------------------
Error: ORA-01430: column being added already exists in table
Cause: You tried to add a column to a table, but the column name already exists in that table.
Action: The options to resolve this Oracle error are:
Rewrite your ALTER TABLE command to create a column with a unique name. Each column name must be unique within a table.

For example, if you had a table called suppliers defined as follows:

CREATE TABLE suppliers
( supplier_id number not null,
supplier_name varchar2(50) not null,
city varchar2(30),
state varchar2(2),
zip_code varchar2(10) );

And you executed the following ALTER TABLE command:

ALTER TABLE suppliers
ADD supplier_name varchar2(50);

You would receive the following error message:
The column called supplier_name already exists. Each column name in your table must be unique.