Re: Dropping and creating tables on the fly

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: Andrew.Kerber@xxxxxxx
  • Date: Tue, 8 May 2007 12:43:15 -0500


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

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: