ORA-08694
Cannot rename a table referenced in SQL assertion.
Cause
Renaming a table referenced in a SQL assertion is not supported.
Action
Drop the SQL assertions in which the table is referenced and then try renaming the table.