Re: Tablespace SYSTEM

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 4 Dec 2001 10:40:30 -0000
Message-ID: <3c0ca824$0$8508$ed9e5944@reading.news.pipex.net>

In sqlplus using a DBA login

alter tablespace system add datafile 'some filename appropriate for your system goes here' size 50M;
or
alter database datafile 'your system datafile name goes here' autoextend on next 10M;

You should also take a look at the database administrators guide in the documentation which gives good clear guidelines on managing storage.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Sylvain GRAVERON" <sylvain.graveron_at_rlf-rj.com.fr> wrote in message
news:9uhv4d$1cq$1_at_reader1.imaginet.fr...


> Tks you

> how to do ?

> Tks a lot

> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> a écrit dans le

> message de news: 3c0b8bce$0$227$ed9e5944_at_reading.news.pipex.net...

> > yes. add a second datafile (preferred) or set autoextend on on one of

the


> > existing data files

> > --

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> > *****************************************

> > Please include version and platform

> > and SQL where applicable

> > It makes life easier and increases the

> > likelihood of a good answer

> >

> > ******************************************

> > "Sylvain GRAVERON" <sylvain.graveron_at_rlf-rj.com.fr> wrote in message

> > news:9uft4f$ch2$1_at_reader1.imaginet.fr...

> > > Hello (I french man)

> > > His possible to extend the Tablespace SYSTEM.

> > > Pct in use = 99

> > >

> > > Tks a lot

> > > Sylvain

> > >

> > >

> >

> >

>
>

Received on Tue Dec 04 2001 - 04:40:30 CST