-
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,…
-
msmtp compile and install
This is kind of my own Linux admin study notes. Like most of my other posts, it can be dry and boring;) In an earlier post, I talked about my desire to compile Mutt and use it as my primary email client. Note there is a little more information on the comment section. Things have…
-
Use USB Flash Drive on Linux
In Linux, any disk drive has to be mounted first before you can use it. That actually is true for Windows also. But Windows shields a lot of that away from a regular user. Unlike Windows, there is no A: or D: drives for you to go directly in Linux, although I’ve heard that some…
-
Problem: Fedora Core 2 as Virtual PC on Windows
Today I tried to install Linux as a guest OS on Windows Virtual PC. I got Fedora Core 2 late last year during a training. So that is what I tried. I picked “Other” OS and created a new virtual disk. Installation started and I picked Graphic mode installation. The Anaconda hardware probing processing started.…
-
Find out date and time of the last database restore
Sometimes you may have the need to find out the date and time a particular database was last restored. Here is a simple way to do it. It should work in both SQL Server 2000 and SQL Server 2005: use msdb select max(restore_date) from restorehistory where destination_database_name = ‘MyDatabaseName’