Riga Dev Days 2018 CFP

Riga Dev Days 2018 CFP

  • via cfp.rigadevdays.lvRiga Dev Days CFP is open!

NEW: Creating a Table for Exchange With a Partitioned Table

https://docs.oracle.com/database/122/VLDBG/maintenance-partition-tables-indexes.htm#GUID-2DE24EE4-00EB-4D58-A428-8E6CBD7E7F34

Turn On ‘Do Not Disturb’ mode on mac OS X

Keep pressed option key (alt) and click on the Notifications icon which is usually found on top right corner. Easy!

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

Reset Mail Settings

Here is how to reset Mail for Mac OS at the original settings:

~ radu.parvu$ defaults delete com.apple.mail

Enjoy!

Disable Mac OS X Gatekeeper

Ocassionally, there is a need to install an app created by a developer that is not identified by the security policy in place on the Firm’s MacBook.

Here is the short procedure I identified it works for me:

  1. in terminal type: sudo spctl --master-disable
  2. verify with: spctl --status
  3. open the application and quit it
  4. in terminal, type: sudo spctl --master-enable
  5. verify the status: spctl --status
  6. verify that the policy is restored via: System Prefrerences … -> Security and Privacy  -> General

Oracle Live SQL Tool

https://livesql.oracle.com/apex/f?p=590:1000:100225800561367

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.