Re: copy data from one datafile to another?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 04 Jul 2007 20:00:33 +0200
Message-ID: <f6gn7r$bnn$1@news2.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

nodge wrote:
> Hey guys,
>
> second problem today:
>
> is it possible to remove some datafiles from a tablespace and put this
> data back into the remaining datafiles? All datafiles are there for
> the same tablespace. Is there a simple command to do this?
>
> I've got a big tablespace with more then 40 datafiles - each file is
> 400MB. Therer are 4 file which I want to be removed. It's a RAW
> Filesystem and these 4 Files were created on the real file system by
> accident.
>
> Thx
> Nodge
>

Version?!?

iirc only the last versions (10G) can actually drop a datafile from a tablespace -earlier versions simply could not, and assumed data could be in there.
Which is a wise assumption...

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGi+BBLw8L4IAs830RAss+AKCL+WKH42QkjP/DTqbIOGjJEOa2uACfUKIJ D7NPwIyoQuvCTa3lro4clcs=
=ZNRM
-----END PGP SIGNATURE----- Received on Wed Jul 04 2007 - 13:00:33 CDT