-
Failed nbsmtp compile and some Linux and RPM tips
Earlier, I talked about my failed attempt to comiple and install msmtp. I tried to install and compile nbsmtp, and got similar results. Googling revealed that many people would suggest install things from an RPM package. So I searched around and found a msmtp package for Suse, but my web host is on RedHat. I…
-
Generate Oracle objects DDL using dbms_metadata.get_ddl
Since Oracle 9i, Oracle added a new utility called dbms_metadata.get_ddl. This utility provides you with object DDL generated out of Oracle Data Dictionary. It is extremely handy and useful. For example, you can use: set long 500000 select dbms_metadata.get_ddl(‘TABLESPACE’,’TablespaceName’) from dual; to get a particular tablespace’s DDL. You can also use it for users, role,…