Riga Dev Days 2018 CFP
- via cfp.rigadevdays.lvRiga Dev Days CFP is open!
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.
