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 […]
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: […]
Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud. Quite easy to implement, too: The options are:
In DEVONthink, it is quite easy to create and update own templates. They are all stored in:
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…
I had to modify a file for loading into an Oracle database with SQL*Loader. The file was using as field delimiter the | pipe character and each line was ending in a |. So ideally, I would like to remove the pipe chracter that ends each of the 384 016 850 lines of my text […]
Keep pressed option key (alt) and click on the Notifications icon which is usually found on top right corner. Easy!
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 […]
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 […]
