Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Tablespace Question
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:11:23 CDT
![]() |
![]() |