Home » RDBMS Server » Server Administration » system tablespace full (Oracle database)
system tablespace full [message #286702] Sun, 09 December 2007 22:39 Go to next message
shachipathak
Messages: 16
Registered: December 2007
Location: Bangalore
Junior Member
Dear Sir,
At times when i create a new user(with dba privilege) and give it some tablespace X(alter command).

When i start an import the data of an existing user (with dba privileges), to the new user , the 'system' tablespace gets filled instead of the X tablespace.

Thanks
Shachi
Re: system tablespace full [message #286703 is a reply to message #286702] Sun, 09 December 2007 22:51 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Either precreate the table in other tablespace or don't give dba/unlimited privilege on system tablespace to the intended user and also make default tablespace to other tablespace rather than system.
Re: system tablespace full [message #286704 is a reply to message #286702] Sun, 09 December 2007 23:12 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is possible to get this error when you create (during import) a table/index/... as Oracle records this new table/index/... in dictionay and then may need to enlarge one of these dictionary tables.

Regards
Michel
Previous Topic: 9i installation error
Next Topic: Reinstallation of ORACLE
Goto Forum:
  


Current Time: Fri Dec 09 02:15:14 CST 2016

Total time taken to generate the page: 0.06359 seconds