alter column errors

zhymin77 2009-08-26 02:44:32

2009-08-26 14:38:42,562 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:156) - ORA-01430: 表中已经存在要添加的列

2009-08-26 14:38:42,593 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:155) - Unsuccessful: alter table Employees add name varchar2(25 char)
2009-08-26 14:38:42,593 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:156) - ORA-01430: 表中已经存在要添加的列

2009-08-26 14:38:42,625 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:155) - Unsuccessful: alter table Employees add note varchar2(100 char)
2009-08-26 14:38:42,625 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:156) - ORA-01430: 表中已经存在要添加的列

2009-08-26 14:38:42,640 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:155) - Unsuccessful: alter table Employees add sex varchar2(5 char)
2009-08-26 14:38:42,640 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:156) - ORA-01430: 表中已经存在要添加的列

2009-08-26 14:38:42,656 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:155) - Unsuccessful: alter table Employees add birthday date
是什么原因呢????

...全文

133 3 打赏收藏转发到动态举报

写回复

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

lihaifeng0412 2009-08-26

打赏
举报

回复

没有遇见过

jinchun1234 2009-08-26

打赏
举报

回复

数据库中已经有该列？

guodong66 2009-08-26

打赏
举报

回复

汗~ 没看懂，你解释下吧这个是不是你用hibernate 写完bean 然后SchemaExport表的时候出的错？

Latest version 7.3.0.651 Released 10/31/2016 7.3.0.651 - 31st October SQL Prompt can now retrieve suggestions using Azure Active Directory password authentication (UserVoice) Formatting off comment tag now applies to itself (forum post) Fix for text being moved inside formatting off comment tags (Forum post) Support ticket 76423: ambiguous columns are now always qualified with their table/alias inside an ORDER BY clause 7.3.0.642 - 27th October Support for user account licensing (More info) 7.3.0.639 - 26th October Fix for insert semicolons error being displayed when trying to format a script in older versions of SSMS2016 (UserVoice and Forum post) Place first item on new line now works for ORDER BY in windowed functions (Forum post) 7.3.0.632 - 24th October Format action added for applying column alias style (UserVoice) Option added to change CREATE/ALTER parentheses separately from the global parentheses options Option added to insert an empty line between JOIN clauses Ole db provider names are now suggested for OPENROWSET and OPENQUERY Fix for incorrectly qualifying a column using the xml "modify" method (Forum post) Fix for syntax error being introduced when wrapping long lines containing multi-line strings 7.3.0.619 - 17th October Fix for script not being formatted if there are errors outside of the selected text (UserVoice) Whitespace at the end of the file is now maintained if "Preserve existing new lines between statements" is checked (UserVoice) Statements inside TRY/CATCH blocks are now formatted the same as BEGIN/END blocks Fix for parentheses alignment inside CASE expression (Forum post) 7.3.0.610 - 11th October Experimental feature added to refresh the SSMS IntelliSense (UserVoice) Fix for IN parentheses not being aligned correctly (Forum post) Fix for parentheses in VALUES clause not being aligned (Forum post) Renaming the file that a style is stored in will now rename the style Support ticket 74368: Fix for a semicolon being incorrectly added on an ALTER table statement with a masked column 7.3.0.598 - 6th October Formatting now indents nested JOIN clauses correctly Fix for formatting issue where line breaks were removed incorrectly after multi-line comments (Forum post) EXEC statements with a return value are now formatted Fix for formatting issue where whitespace was added after aliases (Forum post) Improved formatting for CREATE/ALTER with temporal tables Improved suggestions for ALTER with temporal tables Fix for issue with insert semicolons and temporal tables 7.3.0.587 - 3rd October Tables used in JOIN clauses are now treated as subsequent items (Forum post) 7.3.0.585 - 30th September Added new formatting options for JOINs Fix for formatting failing when right aligning AS keyword in CTEs Formatting no longer fails with some Azure Data Warehouse -specific statements Fix formatting for negative numbers in CASE expressions (Forum post) Fix for formatting failling with SELECT into variable with += (Forum post) 7.3.0.564 - 22nd September Fix for formatting failing on some scripts (Forum post) Option for adding spaces around parentheses contents is now used in more statements 7.3.0.564 - 20th September Support for formatting scripts containing SQLCMD mode and "GO 10" syntax New format action for adding/removing AS keyword for table/view alias definitions Simplified the parentheses "Place on new line" options ALTER DATABASE statements now respect the "Indent DDL clauses" option (Forum post) Column names in temp tables using quoted identifiers are now suggested Inline EXEC now correctly handles parameters using the DEFAULT value Fix for incorrect indentation when using UNION Fix for missing space in ORDER BY between function call and DESC keyword Fix for extra space being inserted between "<=" Fix for extra space being inserted after minus inside IN clause (Forum post) Support ticket 73192: Fix for Inline EXEC not inlining negative variables correctly Support ticket 73072: Fix for cancel button not responding when using "Open in Excel"

　　　　　　　　　　　　　　　SQL语法基础之ALTER语句　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　作者：尹正杰版权声明：原创作品，谢绝转载！否则将追究法律责任。一.查看ALTER的帮助信息 mysql> ? ALTER Many help items for your request exist. To make a mo...

KEYWORD!&()*+,-./:<<<=>@AABORTACCESSACCESSEDACCOUNTACTIVATEADDADMINADMINISTERADMINISTRATORADVISEADVISORAFTERALIASALLALLOCATEALLOWALL_ROWSALTERALWAYSANALYZEANCILLARYANDAND_EQUALANTIJOIN...

数据库版本：12.2.0 操作系统版本：RHEL7.2 最近观察到一个数据库alert日志老是报硬解析太多错误，且对应的sql语句都是查看数据字典表： 2017-06-16T08:46:46.417468+08:00 TTEST(4):WARNING: too many parse errors, count=100 SQL hash=0x03b29074 TTEST(4):PARS...

墨墨导读：你是否足够了解在生产环境上执行drop column操作或者类似的DDL操作有多危险？生产环境的一张大表上执行了一个drop column，导致业务停止运行几个小时，这样的事情...

81,092

社区成员

341,716

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章