Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Moving tables - URGENT

Moving tables - URGENT

From: Cherie Machler <n32cmn_at_is.nwa.com>
Date: 1997/10/14
Message-ID: <34439BBE.57E5@is.nwa.com>#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 Tue Oct 14 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US