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

Other related posts: