Re: Tablespace SYSTEM

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 4 Dec 2001 14:21:05 -0000
Message-ID: <3c0cdbd7$0$8509$ed9e5944@reading.news.pipex.net>

Lazy thinking.

In fact I like to keep datafiles at regular sizes if possible just for ease of data layout. However what I had in mind was that autoextend was bad. I didn't consider manually resizing. This is an omission. so the alternative andrew suggests would be

alter database datafile 'your system datafile goes here' resize <new larger size>;

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

******************************************

"andrew_webby at hotmail" <andrew_webby_at_hotmail.com> wrote in message
news:f45d9b0.0112040351.27769c6f_at_posting.google.com...


> Out of interest Niall, why do you recommend adding a datafile instead of

> (manually) extending the existing file?

>

> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message

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

Received on Tue Dec 04 2001 - 08:21:05 CST