Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large table monthly switch design problem
Hi DA Morgan,
[...]
> What you describe is a nightmare.
> Why aren't you using Partitioning?
We currently *are* using partitioned tables, and it *is* a nightmare, because in order to satisfy the quality check team we need to create a (partitioned) copy of the original (partitioned) table in order to allow them a real world test before putting it into production.
I'm looking for a way to circumvent creating a copy of the fact table.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Wed Jun 29 2005 - 09:35:31 CDT