ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE
Cause: A statement contained both [NO]LOGGING and [UN]RECOVERABLE clauses which is disallowed.
Action: Remove one of the offending clauses. [UN]RECOVERABLE is being deprecated in V8 and will be obsoleted in V9. To duplicate semantics of UNRECOVERABLE clause, create an object with NOLOGGING option and then ALTER it specifying LOGGING. To duplicate semantics of RECOVERABLE clause, create an object with LOGGING option.
。
ORA-14103:LOGGING / NOLOGGING与RECOVERABLE / UNRECOVERABLE不能结合使用
ORA-14103表示在启动数据库时,用户尝试同时使用LOGGING或NOLOGGING选项和RECOVERABLE或UNRECOVERABLE选项,然而这两种操作不能同时使用。
一般来说,作为管理员,你可能会遇到这个错误。在启动Oracle数据库或进行一些操作时,你可能会尝试启用 Recovery 选项,如 LOGGING和 NOLOGGING,你可能想把RECOVERABLE和UNRECOVARABLE也给加上,但Oracle不允许你同时使用这两者,因此你可能会收到ORA-14103。
Oracle不允许同时使用LOGGING / NOLOGGING和RECOVERABLE / UNRECOVERABLE选项。如果你收到这个错误,请确保你只使用一个选项。
本文标签:ORA-14103 LOGGING NOLOGGING may not be combined with RECOVERABLE UNRECOVERABLE
原文链接:
版权说明: 本文由作者上传,本站仅提供存储服务,转载请注明原文链接