Profile cover photo
Profile photo
Abdul Halim
Abdul's posts

Post has attachment
Copy a table from one database to another database in Oracle
We can use any of following  method to copy one table from one database to another database. 1) using create table as select with help of DB_LINK between two databases create table target_table_name as select * from source_table_name@dblink  2) Using Legacy...

Post has attachment
How to Generate or Create ERD diagram with Oracle SQL Developer- Version
1)      Make an connection to your schema 2)       Then Go to tab < > --> Data Modeler --> Browser   (double click) . it will open a
window like below screen                  3)       Then Right click on Relational   Models --> New relational models 4)     ...

Post has attachment
/bin/sh^M: bad interpreter: No such file or directory
Very simple thing but some it
will bother you a lot.  I tried to run a shell script   “” but it was
giving me following error /bin/sh^M:
bad interpreter: No such file or directory Solution was:    Run following script like below to...

Post has attachment
ORA-24247: network access denied by access control list (ACL) IN ORACLE 11G
You might face this issue when you will work with SMTP-SERVER for sending EMAIL from ORACLE DATABASE through Oracle packages. [ NOTE:  THIS IS FOR ORACLE 11G ] As of Oracle 11g a new package DBMS_NETWORK_ACL_ADMIN allows fine-grained control over network ho...

Post has attachment
A user name and password are being requested by http://:. The site says: “XDB” in Oracle APEX
Hi, After Installation Oracle Apex, whenever I tried to connect in Oracle APEX environment with following URL http://localhost:8080/apex   It was saying - A user name and password are being requested by http://:. The site says: “XDB”    (In apex version 4.2...

Post has attachment
ORA-00904 string: invalid identifier
Hi, Recently we faced this issue when we renamed a column and changed columns datatype of a table which have a function based index on it. Symptom:-    After this change, whenever we were trying to query this table it says above error. Solution:    Our prob...

Post has attachment
Failed to connect to remote database Error is ORA-01017
Hi, You may encounter above error in oracle dataguard environment - if you     1) change the SYS user's password or 2) change the SYSDG user's password - in 11g and above or 3) remove any of password files  or 4) remote_login_passwordfile parameter is not s...

Post has attachment
emctl is not working in oracle 12c and How to manually configure EM Express
From oracle 12c, there is no command
like “emctl start dbconsole” , because in 12c there is no
DBCONSOLE ( no middle-tier). In replace Oracle has introduced EM Express. What is EM Express and its
Architecture? Oracle Enterprise Manager Database
Express, al...

Post has attachment
Daily Oracle DBA Checklist - For Production
Daily Production Oracle DBA checklist                                                Here I’ve
mentioned lot of Daily activities of a production Oracle DBA (based on my
experience). Actually it totally depends on your Database’s characteristics,
Size of Dat...

Post has attachment
Wait while more posts are being loaded