System tablespace

[Hakimca]

Hi,

I want to move system tablespace's datafiles from one disk to another. Can I put the tablespace system offline. Is it safe to do it


Thanks

[aarroyob]

You can't do this.

1. Shutdown normal your database.
2. Copy the system datafile where you want
3. Startup mount
4. Alter database rename datafile 'old_path_for_system_datafile' to 'new_path'
5. Startup open

Regards

Angel

[KenEwald]

1. backup
2. create a backup controlfile script
"alter database backup controlfile to trace"
this file will be in the udump directory
copy it, modify it with the new system tblspace file locations
remove the comments - svrmgrl/sqlplus don't like them

3. shutdown the database
4. move the system tblspace data file(s)
5. run the script modified in step 2

-Ken

[Hakimca]

Thank you Angel and Ken.

Angel, I am using Oracle 8.1.7 on windows NT and it's

Instead of

ALTER DATABASE RENAME DATAFILE ...

I used

ALTER DATABASE RENAME FILE ...

[marist89]

Originally posted by Hakimca
Thank you Angel and Ken.

Angel, I am using Oracle 8.1.7 on windows NT and it's

Instead of

ALTER DATABASE RENAME DATAFILE ...

I used

ALTER DATABASE RENAME FILE ...

That's funny. I'm on Unix and it's ALTER DATABASE RENAME FILE also...

[sambavan]

http://technet.oracle.com/docs/produ...dfiles.htm#636

Sam

[sumi_ocp]

when u say

ALTER DATABASE it should be rename file to ' .....


and when u say

ALTER TABLESPACE
it should be rename datafile to '.....

[aarroyob]

Originally posted by marist89
That's funny. I'm on Unix and it's ALTER DATABASE RENAME FILE also... [/B]

Yeah,

A bug on my brain

Regards

Angel