This content has been marked as final. Show 3 replies
The SYSTEM Tablespace datafile will always have the status 'SYSTEM' in the V$DATAFILE view. This is the case with all your databases -- including the Primary for this Standby.
The reason why SYSTEM is status 'SYSTEM' while others can be 'ONLINE' or 'OFFLINE' is that the SYSTEM tablespace can never be 'OFFLINE'. It cannot be manually taken Offline or brought Online.
So setting the status 'SYSTEM' is to say 'it cannot be offline or online, it is not treated the same as other datafiles'
Hemant K Chitale
Thanks for the answer.
Yes you're right the system datafile has SYSTEM status.
Do you know how can I create standby datafile in system tablespace using the command :
alter database create datafile
Should the command(s) be different for system tablespace ?
I used the command
ALTER DATABASE RENAME FILE