Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Moving tables and constraints
We have a number of tables which we're moving from regular disk to RAID, and are resizing the tablespaces at the same time. Some of these tables are referenced by forign key constrains in many other tables. Here's what we end up doing:
The problem is, we're running into tables with scores of foriegn key constraints, and this is becoming quite tedious (since the system has to be down while we do this).
Is there a better way?
Thanks! Received on Sat Dec 20 1997 - 00:00:00 CST