Tablespace Question
From: Ed <ed_zep_at_ntlworld.com>
Date: 18 Jun 2003 12:11:23 -0700
Message-ID: <58e9f9da.0306181111.13c42811_at_posting.google.com>
Date: 18 Jun 2003 12:11:23 -0700
Message-ID: <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.