Moving tables - URGENT

From: Cherie Machler <n32cmn_at_is.nwa.com>
Date: 1997/10/23
Message-ID: <62msr4$rc0$8@195.26.68.19>#1/1

Here's our situation:

Our third-party vendor app builds all of it's tables and indexes and software, etc. if they do not exist in a particular tablespace. From that point forward, it accesses these tables in that tablespace.

We have the largest database this vendor has ever worked with. We are physically limited so we are only able give this single tablespace about half the space it needs (20 GIG). We had to create a second tablespace to hold the tables. We need to move some of the tables from the first tablespace to the second. We can not drop the tables and recreate them in the other tablespace.

What are the other options?

Thanks in advance,

Cherie Received on Thu Oct 23 1997 - 00:00:00 CDT