How to change the Apex Application from LTR to RTL?

If you are developing Arabic application using Oracle Apex and want to change the the direction of the whole application from LTR(Left-To_Right) to RTL (Right-To-Left) , heer are the quick steps: 1- Select the application Select Shared Components. then select "Globalization" Then set the "Document Direction" attribute to "Right-To-Left" That is all! ThanksAhmed

sqlcl Multi-Line Paste Issue

What is the issue? I noticed that sometimes when I copy SQL statement from web and paste it on sqlcl , it is copied on many lines and generating errors. For example, when I copied the following statement: And pasted into sqlcl running on the windows command window, it was pasted as follows: So, it … Continue reading sqlcl Multi-Line Paste Issue

Oracle tnsnames.ora Distribution Management System!

What? Does tnsnames.ora file need a Distribution Management System? In our case, the answer is yes. It is a headache to implement our client requirements without some sort of automation. What is tnsnames.ora file? tnsnames.ora is a text file that resides on the ORACLE_HOME/network/admin and contains some simple information about our databases connection information, it … Continue reading Oracle tnsnames.ora Distribution Management System!

Oracle Database 32-bit Funny Migration to 64-bit

Objective: Migrating one 11.1.0.7 32-bit database that resides on an old Windows 2008 (32-bit) (4GB memory) to Windows 2008 64-bit (no upgrade) on a brand new server with 64GB memory. {At 2017 and still there is 11.1.0.7 database ==> yes there is!} Introduction and Background I have a client with the following very old environment: … Continue reading Oracle Database 32-bit Funny Migration to 64-bit

Oracle Data Pump Import Log File Analysis

In most (or all) cases , when you fully import the database using oracle data pump or the old “imp” import utility , you will get some errors. Some of them are expected and could be ignored and some need close attention to investigate and fix. For big databases, the import log file may be … Continue reading Oracle Data Pump Import Log File Analysis