Oracle Client

Difference between Oracle Client and Oracle Instant Client

Posted on
Here I list their differences including features, pros and cons for you to evaluate which one should be used for your clients: Oracle Client Features Install-based software All-in-one functions General-purpose package Oracle database enterprise edition download page Oracle clients stay with Oracle database software, so there’s no dedicated download page for Oracle clients. Pros One-stop […]
RMAN

How to Set NLS_DATE_FORMAT in RMAN

Posted on
After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log, which was too coarse to judge the actual time like this: 08-OCT-12 Set NLS_DATE_FORMAT for RMAN If you are using sqlplus, you can ALTER SESSION SET NLS_DATE_FORMAT to modify the date format, but […]