>
> We encreased the size of the tablespace for T25, but what is the
> default size
> of tablespaces on ORACLE. Is there a possibe to set that manualy
> to increase
> automaticly?

Remedy(default) set the tablespace extents to 1048576 and max number of
extents to 999

select * from dba_tablespaces where tablespace_name = 'ARSYSTEM'

--
Jarl Grøneng
jgroneng@online.no

Now playing: Nothing, probably working.....


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Hi,

we just runned into a problem unter the following config.
HP11
Oracle 8.05 with 7.3.4 Client
ARS 4.02

The following Error comes back :
ARERR (552) Faliture douring SQL operation to the DB: XXXX unable to extend
table ARADMIN.T25 by 62 in tablespace ARSYSTEM.

We encreased the size of the tablespace for T25, but what is the default size
of tablespaces on ORACLE. Is there a possibe to set that manualy to increase
automaticly?

Thanks

Markus

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

It is possible to change to autoextend. You can make this with "Oracle storage manager" a Oracle Enterprise tool, but next I show you a example in SQL:

1. Create a tablespace TEST with a datafile TEST:

CREATE TABLESPACE TEST DATAFILE 'TEST' SIZE 1M;

2. You have to change the datafile TEST to autoextend (in this example the extend size is 10 Mbytes):

ALTER DATABASE DATAFILE 'TEST' AUTOEXTEND ON NEXT 10M;

3. Normally you need to change the tablespace extents configuration, by default it starts by 10 Kbytes increasing by 50% greater until 121 extents. The following example change this to 10 Mbytes increasing by 60% greater until no limit extents:

ALTER TABLESPACE "TEST" DEFAULT STORAGE ( INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED PCTINCREASE 60 );

4. The following drops the tablespace TEST:

DROP TABLESPACE "TEST" INCLUDING CONTENTS;

Regards,
Domingo del Moral
Ericsson Business Consulting Spain

-----Original Message-----
From: Remedy Projekt [mailto:RPROJEKT@DBMAIL.DEBIS.DE]
Sent: Wednesday, January 05, 2000 4:03 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Tablespacesize under Oracle



Hi,

we just runned into a problem unter the following config.
HP11
Oracle 8.05 with 7.3.4 Client
ARS 4.02

The following Error comes back :
ARERR (552) Faliture douring SQL operation to the DB: XXXX unable to extend
table ARADMIN.T25 by 62 in tablespace ARSYSTEM.

We encreased the size of the tablespace for T25, but what is the default size
of tablespaces on ORACLE. Is there a possibe to set that manualy to increase
automaticly?

Thanks

Markus

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist