Oracle Instant Client for macOS (Intel x86)

Oracle does not release anymore full client packages for the Mac clients. Therefore, we need to use the Instant Client from: https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html The installation is quite simple but we need to rememeber that, in order to have a functional client for a DBA we would need to download three packages at least: Basic Package – All files required to run

Read more

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

Read more

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

Read more