Oracle Solution for Error ora-43807
ORA-43807: indexes on ORA_ROWSCN not allowed
What triggered the Error:
An attempt was made to create an index that refers to the ORA_ROWSCN pseudo-column, either directly or in an expression.
What should we do to fix it:
Do not use ORA_ROWSCN to define an index on a table.