|
Moving datafile will not remove it from SYSTEM
tablespace. You can not reassign datafile from one tablespace to
another.
Now I'm not sure, what are trying to do?
Did you find may be "user" objects in SYSTEM tablespace?
Then, it's totally different story.
----- Original Message -----
Sent: Tuesday, July 09, 2002 10:38
AM
Subject: Re: What is the point to use
"alter database rename file" command?
Well, I have recieved a server and found some datafiles
are reside
in System tablespace - in this case to move
those datafile we can not put
system tablespace offline
therefore can not use alter command...
Regards,
-Jalil
Rachel Carmichael <[EMAIL PROTECTED]>
wrote:
well,
I can think of one off the top of my head -- your way the
database has to
be shutdown.
using alter database rename file you can just take the
tablespace that
owns that datafile offline and do the work. All users who
don't need
that particular tablespace are not affected.
---
Jalil Zabourdine <[EMAIL PROTECTED]>wrote:
>
> Hi list,
>
What is the point to use "alter database rename file"
> command to
move datafile? as we will need to update
> controle file anyway. So
why not do the following directly
> to move datafile:
> - alter
database backup contrlfile to trace and modify
> the location of
datafile.
> - startup nomount and run the script inorder to update
> the controlfile. It works fine...
>
> So what is the
point of "alter database rename file" command?
>
> Thanks i! !
n advance.
> Regards,
> -Jalil
>
>
>
> ---------------------------------
> Do You Yahoo!?
>
New! SBC Yahoo! Dial - 1st Month Free & unlimited
access
__________________________________________________
Do
You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month
Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Rachel Carmichael
INET:
[EMAIL PROTECTED]
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:
[EMAIL PROTECTED] (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!?
New! SBC
Yahoo! Dial - 1st Month Free & unlimited
access
|
