system tablespace

[mkey]

hi all,
i'm tring to install an app and i'm getting increase the system tablespace to 1024kb error. when i check the system tablespace through dba studio under storage i see 350mb allocated. where else should i check the size of the system tablespace.

Thanks!

 

[mkey]

in addition i am working on the default database ORCL of oracle 8i which is on my local pc.

 

[mkey]

The third party tool i'm tring to install in the file net.Why does it needs to acces the system tablespace?

 

[Turkbear]

Hi,
I would avoid like the plague any app that tries to put objects in the SYSTEM tablespace unless it is an Oracle supplied App.

I do not understand your last statement
The third party tool i'm tring to install in the file net.

what tool?

 

[mkey]

SORRY!
The third party tool i'm tring to install IS FileNet!

 

[ThomVF]

Unfortunately, some packages ask you to connect as SYSTEM to load their objects, but as we know, SYSTEM's default tablespace is SYSTEM and some of these guys do not allow for a tablespace prompt in their statments (ridiculous).

If they absolutely must have you log in as SYSTEM, and there is no prompt/parameter for the tablespace, you could "temporarily" change SYSTEM's default to TOOLS, or some other place.

Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[mkey]

I have checked the system user. The default is in Tools.

 

[DSEyers]

Maybe there is not enougth continous freespace in the system tablespace? (I think probably not unless you have a lot of packages and no other rollback tablespace!)

You can check this via some script available at

http://www.dbaoncall.net/

under the oracle section (a very good site and its not mine!)

I assume the error/warning message was via the application? Was there an ORA- Error?

You could also look in the instance alert log. This is a VERY good place to look when things do not work. Oracle say look at it every day for any errors! Can also help in Performance Tuning.