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!
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: in terminal type: sudo spctl --master-disable verify with: spctl --status open the application and quit it in terminal, type: sudo spctl --master-enable verify the status: spctl […]
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. It is same with Index renaming.
