Monday, 23 January 2012

ORA-02237: invalid file size

ORA-02237: invalid file size

Cause: A non-integer value was specified in the SIZE or RESIZE clause.

Action: Use correct syntax.

ORA-02236: invalid file name

ORA-02236: invalid file name

Cause: A character string literal was not used in the filename list of a LOGFILE, DATAFILE, or RENAME clause.

Action: Use correct syntax.

ORA-02235: this table logs changes to another table already

ORA-02235: this table logs changes to another table already

Cause: the table to be altered is already a change log for another table

Action: Don t log changes to the specified base table to this table; check that the replication product s system tables are consistent

ORA-02234: changes to this table are already logged

ORA-02234: changes to this table are already logged

Cause: the log table to be added is a duplicate of another

Action: Don t add this change log to the system; check that the replication product s system tables are consistent

ORA-02233: invalid CLOSE mode

ORA-02233: invalid CLOSE mode

Cause: A mode other than NORMAL or IMMEDIATE follows the CLOSE keyword in an ALTER DATABASE statement.

Action: Specify either NORMAL, IMMEDIATE, or nothing following CLOSE.

ORA-02232: invalid MOUNT mode

ORA-02232: invalid MOUNT mode

Cause: A mode other than SHARED or EXCLUSIVE follows the MOUNT keyword in an ALTER DATABASE statement.

Action: Specify either SHARED, EXCLUSIVE, or nothing following MOUNT.

ORA-02231: missing or invalid option to ALTER DATABASE

ORA-02231: missing or invalid option to ALTER DATABASE

Cause: An option other than ADD, DROP, RENAME, ARCHIVELOG, NOARCHIVELOG, MOUNT, DISMOUNT, OPEN, or CLOSE is specified in the statement.

Action: Specify only legal options.