Re: Where is a temp tables DDL stored?

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 15 Sep 2005 08:26:16 -0700
Message-ID: <1126797976.361072.301250@z14g2000cwz.googlegroups.com>

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 Received on Thu Sep 15 2005 - 10:26:16 CDT