The database needs to started in MOUNT state before you can rename the
SYSTEM tablespace's data file. See proof below.
Perhaps the list is just as scared of you as you are of it. ;-) Just
kidding. :-)
-Todd
SQL> alter system checkpoint;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> $ocopy C:\oracle\oradata\dba1\SYSTEM_01.DBF
C:\oracle\oradata\dba1\SYSTEM_02.DBF
C:\ORACLE\ORADATA\DBA1\SYSTEM_02.DBF
SQL> startup nomount pfile=C:\oracle\admin\dba1\pfile\initdba1.ora
ORACLE instance started.
Total System Global Area 80812656 bytes
Fixed Size 453232 bytes
Variable Size 67108864 bytes
Database Buffers 12582912 bytes
Redo Buffers 667648 bytes
SQL> alter database rename
2 file 'C:\oracle\oradata\dba1\SYSTEM_01.DBF'
3 to 'C:\oracle\oradata\dba1\SYSTEM_02.DBF';
alter database rename file 'C:\oracle\oradata\dba1\SYSTEM_01.DBF'
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
Database altered.
SQL> alter database rename
2 file 'C:\oracle\oradata\dba1\SYSTEM_01.DBF'
3 to 'C:\oracle\oradata\dba1\SYSTEM_02.DBF';
Database altered.
SQL>
-----Original Message-----
From: James Oddo
[mailto:oracledba-ezmlmshield-x37530306.[Email address protected]
Sent: Wednesday, May 18, 2005 9:40 AM
To: LazyDBA Discussion
Subject: RE: Move tablespace System
the list is scaring me...
Shutdown DB
Move system tablespace
Startup nomount
Alter location of system tablespace
open database
Done
-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x18459065.[Email address protected]
Sent: Wednesday, May 18, 2005 8:53 AM
To: LazyDBA Discussion
Subject: RE: Move tablespace System
alter tablespace USA3K_MID read only;
alter tablespace USA3K_MID offline;
Physically move or copy files on OS level.
alter database rename file 'D:\ORADATA\AIR09\USA3K_MID02.DBF' to
'E:\ORADATA\AIR09\USA3K_MID02.DBF';
alter database rename file 'D:\ORADATA\AIR09\USA3K_MID01.DBF' to
'E:\ORADATA\AIR09\USA3K_MID01.DBF';
alter database rename file 'D:\ORADATA\AIR09\USA3K_MID03.DBF' to
'E:\ORADATA\AIR09\USA3K_MID03.DBF';
alter tablespace USA3K_MID online;
alter tablespace USA3K_MID read write;
-----Original Message-----
From: Agus Purwanto
[mailto:oracledba-ezmlmshield-x59405496.[Email address protected]
Sent: Tuesday, May 17, 2005 8:14 PM
To: LazyDBA Discussion
Subject: Move tablespace System
Hi,
how to move tablespace system in another disc. Ex. from C: to D:
thanks
ags
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
**************************************************************************************
The information contained in this email is privileged and confidential information intended only for the use of the individual or entity named as recipient. If the reader is not the intended recipient, please be notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please do not disclose this communication to any other person. Please notify us immediately by telephone and return the original to us at the address indicated above. Thank you
Oracle LazyDBA home page