I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I could not change the sqldeveloper.conf SQL Developer config file which was stored in a ‘protected’ location. Using SQL Developer in a foreign, non-English language was […]
Originally posted on Julian Dontcheff's Database Blog:
No introductions needed, the only and only Kerry Osborne: Tell us what you remember about your first experiences with Oracle 2 I was just out of college – my first job. The first day they handed me a set of Oracle manuals (I think there was only…
Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud. Quite easy to implement, too: The options are:
a. First step is the database creation. Quite straightforward: b. Next step is to a connection setup connection from local client: from the main datbase page we click the DB Connection button and download the client credentials: A zip archive will de downloaded into your local client machine. In my case, the file is called: […]
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 – […]
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 […]
