The Ji Village News

Category: Technology

  • 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’