Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Resize tablespace SYSTEM
This can be done while the DB is open.. Either add a datafile or resize the current one..
alter database datafile '/oradata1/sys01.dbf' resize 200M;
Just modify what's between parentheses to point to the system tablespace file you want to resize.. (select * from dba_data_files)..
Cheers, Robert Prendin
Olivier Bercovitz <oberco_at_club-internet.fr> wrote:
>This is a multi-part message in MIME format.
>--------------494E3FC84A3BBB435811AB55
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hello everybody,
>
>Can I resize the SYSTEM tablespace without risk ??
>And if yes, has the database to be opened or just mounted for this
>operation ??
>(We work on 7.3.4 on AIX 4.1)
>
>Thanks for your precisions.
>Regards. Olivier.
>
>--------------494E3FC84A3BBB435811AB55
>Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Olivier Bercovitz
>Content-Disposition: attachment; filename="vcard.vcf"
>
>begin: vcard
>fn: Olivier Bercovitz
>n: Bercovitz;Olivier
>org: Steria
>adr: ;;;Maisons-Alfort;;94700;France
>email;internet: oberco_at_club-internet.fr
>x-mozilla-cpt: ;0
>x-mozilla-html: FALSE
>version: 2.1
>end: vcard
>
>
>--------------494E3FC84A3BBB435811AB55--
>
Received on Sat Mar 28 1998 - 00:00:00 CST