"damorgan" <damorgan_at_exesolutions.com> wrote in message
news:3C926C5C.9CDC70BB_at_exesolutions.com...
> I do this all of the time. But create a permanent table and when you are
done truncate it. As you will
> be reusing the table it makes no sense to repeatedly create it and drop
it.
>
> Usually I create a STAGING or QUARANTINE schema with its own tablespace
just for this purpose. I don't
> like to mix dirty records with validated records.
>
> But as I said ... you can do it using Native Dynamic SQL. I just strongly
urge you not to as in Oracle
> there is no need to play those SQL Server-type games to get around the
product's weaknesses.
>
> Daniel Morgan
>
<snip>
I like the name QUARANTINE schema. It has the right flavor.
Thanks,
Jim
Received on Fri Mar 15 2002 - 21:32:33 CST
