Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: "Daniel Fink" <danielwfink@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: 15 Sep 2005 08:26:16 -0700
Organization: http://groups.google.com
Lines: 26
Message-ID: <1126797976.361072.301250@z14g2000cwz.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>
   <dgc25p$aup$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com>
NNTP-Posting-Host: 216.88.130.72
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126797981 8213 127.0.0.1 (15 Sep 2005 15:26:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 15 Sep 2005 15:26:21 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=216.88.130.72;
   posting-account=P-kTng0AAAD3g70oUy_l14RYHR_8opyJ
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251608

Jonathan,

I stand corrected. There are plenty of "CREATE TABLE..." statements in
bootstrap$. To be honest, I did not think about that table.

I do find it amusing that the DDL to create the sys.bootstrap$ table is
stored in sys.bootstrap$.

SQL> l
  1* select * from sys.bootstrap$ where obj# = 56
SQL> /

      LINE#       OBJ#
---------- ----------
SQL_TEXT
-----------------------------------------------------------------
        56         56
CREATE TABLE BOOTSTRAP$("LINE#" NUMBER NOT NULL,"OBJ#" NUMBER NOT
NULL,"SQL_TEXT" VARCHAR2(4000) NOT NULL) PCTFREE 10 PCTUSED 40
INITRANS 1 MAXTRANS 255 STORAGE (  INITIAL 56K NEXT 1024K
MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 56 EXTENTS
(FILE 1 BLOCK 377))

Regards,
Daniel Fink