Re: Dropping and creating tables on the fly

Andrew,

I'm not aware of an issue with the data dictionary. Are you thinking of tablespace fragmentation? Here is my thought:

• Ensure these tables are in their own tablespace which is locally-managed.

Temporary tables can help with these issues. They need to be carefully considered. For example, what happens if one load doesn't complete or hangs before the next load starts?

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l