Skip to content

How to Resolve ORA-03001: unimplemented feature

  • by

ORA-03001

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.

  • Table
  • View
  • Sequence
  • Private synonym

Solution

Let's see what object type of it.

SQL> select object_type from user_objects where object_name = 'ADD_JOB_HISTORY';

OBJECT_TYPE
-----------------------
PROCEDURE

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.

Leave a Reply

Your email address will not be published.