Re: Moving tables - URGENT

If I may ask,
why do you need to move the tables?

John Greco
OracleDBA

Cherie Machler <n32cmn_at_is.nwa.com> wrote:

>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