I use 4 steps
1. put the tablespace offline
2. move the datafile at the OS level
3. rename the datafile in Oracle
4. put the tablespace online
- "Weerd de E.C. Kirsten"
<Kirsten.deWeerd_at_Oranjewoud.nl> a écrit : > Hi all,
>
> The simplest things sometimes keep confusing me, so
> I'll just ask
> and see if someone agress or not :-)
>
> I need to move some datafiles around on Hp-UX 10.20
>
> I figure I can do this in two steps :
>
> 1. on the OS : mv original_dir\datafile.dbf
> new_dir\datafile.dbf
>
> 2. in the DB : alter database rename file
> original_dir\datafile.dbf to
> new_dir\datafile.dbf
>
> Correct ???
>
> Greets,
>
> Kirsten
> Living near Antwerp, Belgium
> Working near Breda, Netherlands
>
> --
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Thu Jul 06 2000 - 04:31:36 CDT
