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
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.

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
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: 65084
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.

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

Current Time: Fri Jul 21 12:15:19 CDT 2017

Total time taken to generate the page: 0.12950 seconds