| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Where is a temp tables DDL stored?
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:2c5hi1lcj5ujdr6rkpeq7og4t3ue6n3m0g_at_4ax.com...
> On 14 Sep 2005 13:21:42 -0700, "Daniel Fink" <danielwfink_at_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 2005Received on Thu Sep 15 2005 - 02:16:13 CDT
 |
 |