Re: Move datafiles...

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Sun, 7 Feb 1999 13:35:01 +0100
Message-ID: <79k1di$cpn$1@news.worldonline.nl>

mquesada_at_renault.com.ar heeft geschreven in bericht <nnrp1.dejanews.com>...
>Hi: Im running 7.3.4 on HP UX-10 and i need to move one datafile from a
>tablespace to another one.. Is it possible??, How i can do it??
>Thanks in advance
>Marcelo Quesada
>mquesada_at_renault.com.ar

Hello Marcelo,
NO, from one tablespace to another one is impossible.

You can only rename or move datafiles from disk to disk:

sql> alter tablespace [TABLESPACE_NAME] OFFline ; cp [file_name] [new file_name]

sql> alter tablespace [TABLESPACE_NAME]
      rename datafile [file_name]  to [new file_name]
sql> alter tablespace [TABLESPACE_NAME] ONline ;

good luck, Roelof

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife Received on Sun Feb 07 1999 - 06:35:01 CST