Re: Tablespace Question

From: Dave Hau <davehau_nospam_123_at_nospam_netscape.net>
Date: Wed, 18 Jun 2003 19:42:12 GMT
Message-ID: <3EF0C094.8090300@nospam_netscape.net>

Create a new tablespace with just one datafile, and use Tom's script to move the tables from your current tablespace to the new tablespace:

See:

http://asktom.oracle.com/pls/ask/f?p=4950:8:321066529294412893::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:47812348053,

Cheers,
Dave

Ed wrote:
> 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.
Received on Wed Jun 18 2003 - 14:42:12 CDT