if you did a shutdown of the database, and then do a startup mount, you
don't actually HAVE to take the tablespace offline, as the database
isn't open and technically it isn't online.
If you want to live dangerously, you can do this while the database is
open for business. Then yes, you'd need to take the tablespace offline.
In either case, the syntax for the rename itself is:
alter database rename file
'<full path specification of the old filename>'
to '<full path specification of the new filename>';
Once that is done, you copy the datafile over to where you actually
want it via OS commands, then either alter database open or alter
tablespace online depending on which way you've done it.
Immediately do a "alter database backup controlfile to trace" and as
soon as possible afterwards, do a backup, just to be safe
- Sujatha Madan <Sujatha.Madan_at_cmc.cwo.net.au> wrote:
> Hi,
>
> The SQL syntax is correct.
>
> Looking at the example below, it's for a single datafile in a single
> tablespace. So, stupid question, did you take the tablespace offline
> before
> you did anything?
>
> Cheers,
>
> Sujatha
>
>
> -----Original Message-----
> Sent: Thursday, 31 January 2002 12:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Okay, I don't have the manuals with me and can't for the life of me
> remember the correct syntax to do this...
>
> Is it:
>
> shutdown database
> startup no noumt (or startup mount)
> alter tablesapce evisions
> rename datafile '/full_path/file_name' to '/full_path/new_name';
>
> I'm on 8.1.6 and this complains saying the database isn't open.
>
> It can't be open to rename a datafile...
>
> Thanks,
> Joe
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe LaCascio
> INET: jlacasci_at_wheatonma.edu
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sujatha Madan
> INET: Sujatha.Madan_at_cmc.cwo.net.au
>
> 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).
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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).
Received on Thu Jan 31 2002 - 07:53:08 CST
