Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: "gazzag" <gareth@jamms.org>
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: 15 Sep 2005 09:01:38 -0700
Organization: http://groups.google.com
Lines: 42
Message-ID: <1126800098.081767.80510@o13g2000cwo.googlegroups.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>
   <3ot6mnF7lievU1@individual.net>
   <1126799628.138852@yasure>
NNTP-Posting-Host: 193.130.12.157
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126800104 11133 127.0.0.1 (15 Sep 2005 16:01:44 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 15 Sep 2005 16:01:44 +0000 (UTC)
In-Reply-To: <1126799628.138852@yasure>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=193.130.12.157;
   posting-account=zujbXgsAAAA8hne0tKRbNp7NAGtNgEwN
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251618

I was hoping to let this lie, but you can't help yourself, can you?

>From the Oracle documentation:

------------------------------------------------------------------------------------
Data Definition Language Statements
Data definition language (DDL) statements define, alter the structure
of, and drop schema objects. DDL statements enable you to:

Create, alter, and drop schema objects and other database structures,
including the database itself and database users (CREATE, ALTER, DROP)

Change the names of schema objects (RENAME)

Delete all the data in schema objects without removing the objects'
structure (TRUNCATE)

Grant and revoke privileges and roles (GRANT, REVOKE)

Turn auditing options on and off (AUDIT, NOAUDIT)

Add a comment to the data dictionary (COMMENT)

DDL statements implicitly commit the preceding and start a new
transaction. Some examples of DDL statements are:

CREATE TABLE plants
    (COMMON_NAME VARCHAR2 (15), LATIN_NAME VARCHAR2 (40));

DROP TABLE plants;

GRANT SELECT ON employees TO scott;

REVOKE DELETE ON employees FROM scott;

------------------------------------------------------------------------------------


Not "metadata".  Period.

Or by "we" do you mean Sybrand and yourself?