Error: ORA-00905 when running a create table statement with GENERATED ALWAYS AS clause (91135)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error: ORA-00905 when running a create table statement with GENERATED ALWAYS AS clause
Description

When running a create table statement in the editor, which contains a GENERATED ALWAYS AS clause, there is an 'ORA-00905' or 'ORA-0900' error.
Cause

SQL Navigator does not support the GENERATED ALWAYS AS clause yet.
Resolution

WORKAROUND:
The statement will run successfully in SQL*Plus.
STATUS:
Waiting for fix in a future release of SQL Navigator for Oracle
Defect ID

PT27884897

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title