Re: data file question

[Quoted] This type of change is usually handles by and export/import process also known as reorganization. Just export the tablespace. Truncate (or drop) the tables to reduce archive logging. Drop the tablespace and recreate it however you want it to look. Then import the tablespace contents. Make sure you have all related constraints and indexes to recreate them. This is a simplified explanation of the process. More details are available on the web and in Oracle documentation.

Big Al

terry_stjean_at_my-deja.com wrote:
>
> I have a tablespace with 4 datafiles. Each one is 4000M in size. I
> recently removed a bunch of snapshots which we no longer need and this
> gave us back a lot of space. I want to downsize to 3 datafiles or
> decrease the current datafiles to 3000M. I can't get rid of any
> datafiles because they all have a percentage used. When I try to
> decrease a datafile size, I get a message that the file contains blocks
> of data beyond the resize value.
> Any suggestions?
>
> Terry
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 14 2000 - 00:00:00 CEST