Re: Tablespace Question

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 18 Jun 2003 22:04:34 -0700
Message-ID: <1ac7c7b3.0306182104.4ee157db@posting.google.com>

ed_zep_at_ntlworld.com (Ed) wrote in message news:<58e9f9da.0306181111.13c42811_at_posting.google.com>...
> Hi.
>
> I've copied over a production system to create a new instance and used
> scripts to truncate the necessary tables.
>
> The tablespace I'm wondering about has two datafiles. Now that all
> that data is cleared out I need to get it back into the one datafile.
>
> What's the best way of doing this. I know I can use imp/exp/compress=y
> but we use uniform extent sizes and move objects between tablespaces
> as required.
>
> Any ideas?
>
> We're on Oracle 8.1.7.4.
>
> Thanks.
>
> Ed.

Ed.

what I wonder is - how does a post end up on a 2+ year old thread? really. how does that happen?

Pd Received on Thu Jun 19 2003 - 00:04:34 CDT