Tried to use RENAME TO statement to rename a schema object, but it failed with ORA-03001.
SQL> rename add_job_history to add_job_history_all;
rename add_job_history to add_job_history_all
ERROR at line 1:
ORA-03001: unimplemented feature
ORA-03001 means that the target you used in the statement is not supported by the feature of the statement at this moment. In other words, there're restrictions on such statement, it cannot be done with this type of schema object.
In fact, there're only 4 types of schema object that can use RENAME TO statement to change their name.
- Private synonym
Let's see what object type of it.
SQL> select object_type from user_objects where object_name = 'ADD_JOB_HISTORY';
In this case, the schema object we want to rename is a PROCEDURE which is simply not supported by RENAME TO statement.
If you want to rename a stored procedure like PROCEDURE, FUNCTION or PACKAGE, you should drop the old one then create a new one.