Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!headwall.stanford.edu!newsfeed.stanford.edu!sn-xit-03!sn-xit-10!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Where is a temp tables DDL stored? Date: Thu, 15 Sep 2005 09:15:26 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1126800874.248231@yasure> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com> <1126712247.735544@yasure> <1126716382.588532.161250@g43g2000cwa.googlegroups.com> <1126723858.554220.198110@g43g2000cwa.googlegroups.com> <1126729301.961774.27730@o13g2000cwo.googlegroups.com> <3ot6mnF7lievU1@individual.net> <1126799628.138852@yasure> <1126800098.081767.80510@o13g2000cwo.googlegroups.com> In-Reply-To: <1126800098.081767.80510@o13g2000cwo.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 51 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251621 gazzag wrote: > 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? GRANT and REVOKE are DCL ... not DDL. ;-) http://www.udel.edu/evelyn/SQL-Class1/SQLclass3.html -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)