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
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:
