After many experiences on Oracle the DBA Team of one of my client said :
'You have made an application using dynamic tables created by
CREATE TABLE AS SELECT
Making such a thing is very dangerous because we are sure that in a few months the SYSTEM TABLESPACE would be desorganized and the entire database would be unusable'

These 'temporary dynamic tables' are created and removed on a daily base frequency.

I have, with my long experience on Oracle, to reply that, yes it is a risk but I have never seen such a chaotic scenario.

Is there some one who experienced the chaotic situation predicted

Thank You for your Help

I could not select an option from your poll, because none seemed appropriate for me, but certainly creating temporary tables in your application is very much to be avoided in Oracle. The man who can best explain this is Tom Kyte - see this:

http://asktom.oracle.com/pls/ask/f?p...D:604830985638

Oracle's "global temporary" tables are the way to go.