Re: Tablespace question

From: <raymondlopez_at_my-deja.com>
Date: Fri, 22 Dec 2000 13:17:37 GMT
Message-ID: <91vk9d$55o$1_at_nnrp1.deja.com>

U can move the datafile across without shutting down the database.

take the tablespace offline;

move/copy the concerned datafile to the relevent location
give 'alter tablespace xx rename datafile '/.../../..' to '/.../..';
get tablespace online

thats it.

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 22 2000 - 14:17:37 CET

This message: [ Message body ]
Next message: mike_st0ne_at_my-deja.com: "Re: Tablespace question"
Previous message: Nuno Souto: "Re: Tablespace question"
Maybe in reply to: kryptogenic_at_my-deja.com: "Tablespace question"
Next in thread: mike_st0ne_at_my-deja.com: "Re: Tablespace question"
Reply: mike_st0ne_at_my-deja.com: "Re: Tablespace question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message