12c ddl logging

Posted by

In new releases, its often the little things that really catch my attention.

Like this one…. I love it

SQL> alter system set enable_ddl_logging = true;

System altered.

SQL> create table t ( x int );

Table created.

SQL> drop table t purge;

Table dropped.

SQL> host cat ddl_cdb12.log
diag_adl:create table t ( x int )
diag_adl:drop table t purge

Awesome

3 comments

    1. Hah! You may love it… and Oracle loves it too. Why? It’s additional paid option…

      “The use of the following init.ora parameter is licensed under Oracle Change Management Pack: ENABLE_DDL_LOGGING: when set to TRUE (default: FALSE)”

  1. Many Singaporeans and Expatriates desire to live in a property becfause of the various conveniences that include it, and sometimes because they aare often rregarded
    as a symbol of high status. None the less, investing
    in a inddividual house iis really a reasonably bbig
    investment and there aree various things that you should consider before you basically
    signal the papers and complete the transaction.
    Here are 10 tips that may help you for making your final
    decision or if not make the procedure simpler!

    Many individuals simply dive directly into purchasing a exclusive condominium because their simply property oof
    it is still viewed ass a image of luxury and high-status. Nevertheless, you may want to place more thoubht to the location of the home.
    Prform a tiny homework around the diverse locations in
    Singapore and get the most great place for you personally.
    In the end, there’s actually no hurry in choosing. You could want
    to explore a number of the popular expatriate enclaves such as Dempsey and Holland Village, that are generally the hottest destinations for expats thinking of buying.

    Do you really need to commute by public transport to work? Then looking for a place deeper towards the MRT and bus
    stands must certanly be something you could desire to consider.

    Searching for interior planning services for your condo?
    Clothing make-up and also involve an occasional make-over, as moment go by your likes also and existence adjustments as
    well as your interior environment wishes rebuilding as much because
    the hair. Approaching a professional for commercial interior decoration in Singapore support isn’t only for the wealthy
    and famous.
    singapore condo rental yield (http://singaporecondo1.webnode.com)
    Altering household adornment of your store or office to reveal your
    improvement wishes and wants can be ore discouraging than
    purchasing a couple of items to fresh-up your clothing, bbut using a
    bit of help fro a specialist pro in Singapore can be funny annd the resylt would be rewarding.

    A designer is simply a specific that’s got the
    know-how for developing internal spots but doesn’t have formal mentoring, while a certified designer is an expeerienced
    pro having a degree.

    We’re a family group of 4 (kiddies 8 & 5) considering a go on to Singapore.
    Residing in Melbourne I’m applied to open areas and massive residences.
    What assistance can anyone give me as I negotiate
    with the organization to get a housing allowance.
    I anticipate we will want to send our youngsters to the Ausstralian International School so we will
    want to be close to that.

    As an Aussie thhe culture of condominium and residence living
    is quite foreign. Are the townhouses all they
    are dsmaged around be or can it be better to decide on a more communal
    living approach? At the end-of the time its an indiuvidual
    standard of living choice, but I would welcome opinions from othrs who’ve needed to make the transition.

    singapore condos for rent
    Location is very important but it often has a
    value! The nearer you’re towards the MRT or even to the city, the more expensive the condo
    may be. As an example the pprice tag on a place in Holland Village could
    possibly be twice aas expensive as compared to a place sitfuated in Woodlands.
    You might wat to consider the proximity of universities in your community, if you’ve children.
    Wikipedia features a set of overseas universities in their distinct handles and Singapore.

    Search for supermarkets and convenience stores nearby that will facilitate your final decision
    too. Another part of selecting the most appropriate location is the issue lots of people have about which way the
    flat is facing. So if you are into Feng Shui, you may
    want to look into this even further.

Got some thoughts? Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.