Oracle – Page 2 – Tech and other topics

Oracle Instant Client for macOS (Intel x86)

Posted by rparvuon 26/02/201927/02/2020in Apple, Mac OS X, OracleLeave a comment

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…

Creating a Table for Exchange With a Partitioned Table

Posted by rparvuon 30/08/201712/11/2019in 12cLeave a comment

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

Oracle Live SQL Tool

Posted by rparvuon 22/03/201608/06/2018in OracleLeave a comment

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

Strange error when renaming a table

Posted by rparvuon 08/03/201612/11/2019in 11gLeave a comment

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…