ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations


If we put into schema names to this command, we can deal with ORA-14047 error. This error raise when we put schema name in front of the last_table_name.
 ALTER TABLE CLAML01.EPRPE2015 RENAME TO CLAML01.EPRPE; >>> RAISES ORA-14047 ERROR

Solution:

alter table hr.[prev_table_name] rename to [last_table_name] >> CORRECT ONE

For example

SQL> ALTER TABLE CLAML01.EPRPE2015 RENAME TO EPRPE;

Table altered.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: