Home » Infrastructure » Linux » System tablespace datafiles ( oracle 10g installation on OREL 5)
System tablespace datafiles [message #556625] Tue, 05 June 2012 13:51 Go to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
Hi to all ;

Recently i added two datafiles under "SYSTEM TABLESPACE"
Physically i removed the path what i additionally added (system02.dbf, system.03.dbf')
after i checked file_name  from dba_data_fies.
Still it shows removed file name but physically removed.


" Please Review attached screen shot "
" I know system tablespace cant offline. I removed only addition data files i mean what i added for testing purpose"

Thanks in advance
Thiyagusham.G
  • Attachment: doubt1.png
    (Size: 152.17KB, Downloaded 1275 times)
Re: System tablespace datafiles [message #556630 is a reply to message #556625] Tue, 05 June 2012 14:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> I removed only addition data files i mean what i added for testing purpose"

was the testing successful?
Re: System tablespace datafiles [message #556647 is a reply to message #556630] Tue, 05 June 2012 20:27 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ blackswan

Not finished yet. Waiting for your Reply.

Thanks

[Updated on: Tue, 05 June 2012 20:31]

Report message to a moderator

Re: System tablespace datafiles [message #556648 is a reply to message #556647] Tue, 05 June 2012 20:54 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
restore the DB from backups
Previous Topic: Oracle 11gR2 Installation on RHEL 6.2 with VMWARE
Next Topic: os autentication error
Goto Forum:
  


Current Time: Fri Mar 29 01:30:15 CDT 2024