Re: Where is a temp tables DDL stored?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 16 Sep 2005 22:13:04 -0700
Message-ID: <1126933938.541697@yasure>

mikharakiri_nospaum_at_yahoo.com wrote:
> Jonathan Lewis wrote:
>

>>Just playing devil's advocate, but why couldn't
>>the database reverse engineer the corrected
>>DDL from the data dictionary as the dictionary
>>is updated ?

>
>
> To extend this idea further, I always wondered why the concept of DDL
> is needed at all? Consider
>
> -- create 100 tables TEST1...TEST100
> insert into user_tables -- or, more concervatively, tab$
> as select 'TEST'||rownum table_name, ...
> from dual connect by rownum < 100
>
> insert into user_tab_columns -- or, more concervatively, col$
> ...
>
> commit;

A table that isn't in obj$ or col$ or seg$, etc.

What a fascinating way to destroy an Oracle system. Have you actually tried this? Were you immediately fired?

I hope no one tries this. Devil's advocate indeed.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sat Sep 17 2005 - 00:13:04 CDT