Re: copy data from one datafile to another?

On Jul 4, 2:00 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> -----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-----
Hi Frank,

It is possible in 10G, but the OP said "put this data back into the remaining datafiles". If he drops, he loses :(

Regards,

Steve Received on Wed Jul 04 2007 - 14:21:12 CDT