Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.esat.net!dedekind.zen.co.uk!zen.net.uk!demorgan.zen.co.uk!194.72.9.35.MISMATCH!news-peer1!btnet-feed5!btnet!news.btopenworld.com!not-for-mail
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: Thu, 15 Sep 2005 07:16:13 +0000 (UTC)
Organization: BT Openworld
Lines: 96
Message-ID: <dgb73t$1gd$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com>
References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com> <1126712247.735544@yasure> <1126716382.588532.161250@g43g2000cwa.googlegroups.com> <bvpgi1d7ntj5keemcfgnjv2hkv8c4n9fg7@4ax.com> <1126723858.554220.198110@g43g2000cwa.googlegroups.com> <tlugi15lh587l4ifq86cm4mn2j55tf2dbb@4ax.com> <1126729301.961774.27730@o13g2000cwo.googlegroups.com> <2c5hi1lcj5ujdr6rkpeq7og4t3ue6n3m0g@4ax.com>
NNTP-Posting-Host: host86-131-3-231.range86-131.btcentralplus.com
X-Trace: nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com 1126768573 1549 86.131.3.231 (15 Sep 2005 07:16:13 GMT)
X-Complaints-To: news-complaints@lists.btinternet.com
NNTP-Posting-Date: Thu, 15 Sep 2005 07:16:13 +0000 (UTC)
X-RFC2646: Format=Flowed; Original
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MSMail-Priority: Normal
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251579



"Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote in message 
news:2c5hi1lcj5ujdr6rkpeq7og4t3ue6n3m0g@4ax.com...
> On 14 Sep 2005 13:21:42 -0700, "Daniel Fink" <danielwfink@yahoo.com>
> wrote:
>
>>I think we are disagreeing over semantics.
>>
>>I consider DDL to be the command that creates (or modifies) the object,
>>i.e. CREATE TABLE emp <...>; This command is not stored in the data
>>dictionary.
>
> I don't think we are disagreeing over semantics. It is quite clear you
> are ignorant of how Oracle works, and expect it to work the same way
> as a toy system like MySQL or sqlserver. In that case, please: dream
> on.
>
> --
> Sybrand Bakker, Senior Oracle DBA


Sybrand,

Your manners and your lack of care leave
much to be desired.

Daniel Fink said:
    The DDL for tables is not stored in the data dictionary, though the
    necessary components to reconstruct the DDL for tables are stored
    there. That is why we have had to use OEM, export, dbms_metadata and
    3rd party tools to extract the DDL when needed

You quoted the first line, and commented "utter rubbish" -
presumably having failed to bother to go on to the later lines
of text.

Daniel clarified his point, and explained (gently) what 'ddl' is:
    Where is the ddl stored? Where do you find "create table..."?

    The components of the ddl are stored, you can extract them into a form
    that will give you a command to create the table.


You side-stepped the point, changed the question, and  redefined
the term DDL to mean 'the components', pointed out that you can
save the DDL in a script, and said you didn't see the problem.
    "I am allowed to give you the wrong answer because I don't
    see the problem and I'm not paying attention"
is NOT a valid comment.


Daniel offered you an olive branch:
    I think we are disagreeing over semantics.

    I consider DDL to be the command that creates (or modifies) the object,
                    [jpl - I think a lot of people would agree with that]
    i.e. CREATE TABLE emp <...>; This command is not stored in the data
    dictionary.

    However, all the information to reconstruct this command IS stored in
    the data dictionary and can be extracted using a variety of 
tools/techniques.


Your only response was an insult, summed up by the phrase.
    "It is quite clear you are ignorant of how Oracle works"

Anyone who has read
Next time you decide to be offensive, please wait 24 hours
before hitting the <Send> key, read the thread carefully, and
then decide whether it is appropriate.

Finally, you may care to download and read this pdf
before you decide whether or not Daniel is ignorant
of how Oracle works:
    http://www.evdbt.com/AutomaticUndoInternals.pdf


-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle - Volume 1: Fundamentals
On-shelf date: Nov 2005

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Sept 2005