Oracle 7:moving tablespaces

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 30 May 2003 10:50:31 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703BA7D24@lnewton.leeds.lfs.co.uk>

Try this :

Optional : shutdown and cold backup the whole plot.

create tablespace(s) on the new device(s).

export schemas having objects in the old tablespaces.

alter user <whatever> default tablespace <new_tablespace> quota <something> on <new_tablespace>
quota 0 on <old_tablespace>
quota 0 on SYSTEM;

Import the user's objects into the new tablespace.

Enjoy.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Darksheep's Revenge [mailto:vi_at_cal.it] Posted At: Friday, May 30, 2003 10:18 AM Posted To: server
Conversation: Oracle 7:moving tablespaces Subject: Oracle 7:moving tablespaces

Hi,
To free more space, I need to move tablespaces (data,index,rbs,system and
temp) from an HD to another.
Can anyone explain to me step by step how to do this work whithout loosing
data?

In Storage Manager there is not way to do a "move".

system is a Unix 4.0d over a digital aplha server 1200; oracle 7

tnx a lot. Received on Fri May 30 2003 - 04:50:31 CDT