Home » RDBMS Server » Server Administration » system ts full
system ts full [message #114815] Tue, 05 April 2005 15:00 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hi
the system tablespace seems to be full. can i add a datafile system2 and mount it in a different path eg. /mnt/ora_index/
coz we mount data ts datafiles in index when its full.
thanx
bala
Re: system ts full [message #114827 is a reply to message #114815] Tue, 05 April 2005 15:41 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
You should not be creating your own objects in the system tablespace (if that is the reason it filled up).

Yes you can add a datafile, or you can just set it to autoextend. Where you put it is up to you.
Re: system ts full [message #114834 is a reply to message #114815] Tue, 05 April 2005 16:09 Go to previous message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
great Thanx
Previous Topic: [total 4-question] for--->oracleservice+sid <-- can we have to such services for one database.
Next Topic: User expire after certain time
Goto Forum:
  


Current Time: Fri Sep 27 02:31:19 CDT 2024