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

Report message to a moderator

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.

Report message to a moderator

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: 68686
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 14:05:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.