Re: Where is a temp tables DDL stored?

From: gazzag <gareth_at_jamms.org>
Date: 15 Sep 2005 09:01:38 -0700
Message-ID: <1126800098.081767.80510@o13g2000cwo.googlegroups.com>

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? Received on Thu Sep 15 2005 - 11:01:38 CDT