The Ji Village News

Author: Haidong Ji

  • 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,…

  • It’s a funny feeling

    I normally read books on my train ride to and from work. Today I brought my book to Chipotle on Lake and Franklin. And read it after a Fajita Steak Burrito. The book I am reading is in Chinese. It is a memoir of Li Ao, a very unique writer, commentator, legislator, and TV personality…

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

  • Don’t judge a book by its cover

    I learned the phrase “Don’t judge a book by its cover” from videos of a popular children’s story series, Thomas the Tank Engine. My son has grown out of it now but he was really into it 2 and 3 years ago. If you live in an English-speaking country and have small children at home,…