Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7:moving tablespaces
I think data is still point to old tblspace after importing.
Use emacs editor to change to new name of tblspace anyplace in file and then
import that file.
Correct me if I am wrong.
CH
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA703BA7D24_at_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 - 10:00:38 CDT