SQL Developer: Save a Package (thanks Jeff Smith)

Got this question: Hello @thatjeffsmith ! How I save packege body and packege spec in same archive? #SqlDeveloper — Felipe Pereira (@FelipeR_Pereira) April 27, 2017 Answer: YES. Make sure you select BOTH. Then set your file type. .SQL as requested Now to confirm I’m really getting what I want. Yes, that. SQL Developer will automatically…

via How to Save a Package and Package Body to a .SQL File — ThatJeffSmith



Strange error when renaming a table

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

When we try to rename a table or index name in Oracle, we use a simple command as following

ALTER TABLE[SCHEMA_NAME].[OLD_TABLE_NAME]RENAME TO[NEW_TABLE_NAME];

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.

ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations
ALTER TABLE SCOTT.TABLE_NAME RENAME TO SCOTT.TABLE_NAME2;
ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations
ALTER TABLE SCOTT.TABLE_NAME RENAME TO TABLE_NAME2;
Table altered.

It is same with Index renaming.