Re: Where is a temp tables DDL stored?

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; Received on Fri Sep 16 2005 - 16:07:53 CDT