ORA-00901 错误是一个常见的 Oracle 数据库错误,表示“无效的创建命令”(Invalid create command)。这个错误通常发生在尝试执行一个 SQL 语句时,该语句的语法不正确或者包含了 Oracle 数据库无法识别的元素。针对你提出的问题,我将按照提供的 tips 逐一进行解答: 1. 确认 ORA-00901 错误的具体含义 ORA-00901 错误...
Oracle Database - Standard Edition - Version 12.2.0.1 and later: DBCA create database fails with ORA-00901: invalid CREATE command
CREATE ROW TYPE addr_typ ( Street CHARACTER VARYING (25) City CHARACTER VARYING(20) State CHARACTER (2) PostalCode CHARACTER VARYING (9) ) ; CREATE ROW TYPE addr_typ ( * ERROR at line 1: ORA-00901: invalid CREATE command -- You received this message because you are subscribed to the G...
where the command you quote is valid. Oracle has no 'CREATE ROW TYPE' command so the database is reporting, correctly, that the syntax is invalid. You need to remember that the title of the book is "SQL for Dummies", not "SQL*Plus for Dummies". The text should have clearly identified...