Domain catastrophe?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 22 Jul 2003 10:04:50 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703F08D96@lnewton.leeds.lfs.co.uk>

Morning,

>> i have sum(bytes) for SYSTEM tablespace is 20MB and max(bytes) is the
>> same.

Sounds to me like your SYSTEM tablespace if full up then.

Have you got any users other than SYS using SYSTEM as their default or temporary tablespace ?
If so, best get them out of there and get their objects out of SYSTEM.

select username, default_tablespace, temporary_tablespace from dba_tablespaces;

will tell you who is using what - needs to be run from SYSTEM user though.

If you have nobody using SYSTEM then you'll need to add a datafile to the tablespace or extend the existinig datafile.

alter tablespace system add datafile 'blah/blah/blah.dbf' size ????;

alter database datafile 'whatever_it_ois_called' resize ?????;

again, run this as system user.

Cheers,
Norm.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Tue Jul 22 2003 - 04:04:50 CDT