AUtoextend

[former_member343310]

Hi

One of the tablespaces is showing Autoextend OFF in DBACOCKPIT. How can I make the autoextend option ON,

Ali

[former_member343310]

I think nobody knows this

[Former Member]

If it is big file then use Brtools Utility -> Sapce Managment -

---

> Alter Tablespace -

---

> 3rd option -

---

> Alter Tablespace Action-----> 4th Tablesapce Name

I hope it will help u to change the tablespace mode from offline to online

Thanks

presu

[former_member343310]

No, the command you mentioned only works if you have BIGFILE tablespace type.

[Former Member]

It is Possible to change the status of tablespace from Auto extend off to autoexten on.

connect sys as sysdba

chect the status of Tablespace by command

Seelect status from dba_tablesapces where <tablespace Name>;

then run command

ALTER TABLESPACE <-> AUTOEXTEND ON NEXT 10K MAXSIZE 100K;

Thanks

presu

[former_member343310]

No, I am not using BIGFILE tablesapce option

[Former Member]

Then the question? alter all datafiles in autoextend on with the correct parameters (count how many you have space on file system, (if you have for one tablespace specific file system )) and you will get the same functionality. Regards.

[former_member343310]

Again, I am not asking about Altering DATAFILE.

Autoextend is also a feature of Tablespace and Datafile both.Autoextend of Datafile means datafile can grow upto the Maximum limit of the Tablespace it belongs to. Atuoextend of Tablespace means the file will grow till the Maximum size of the FileSystem.

My Question still remains. -:(

[Former Member]

Are you have bigfile tablespace ? What product do you use? In sap you can't find the BIGFILE tablespace ...

Where you find it ? Regards.

[former_member343310]

There is no option like "Switch on and maintain autoextend mode" for Tablespace in space management

[Former Member]

Once again

if the tablespace is created initially with autoextend off

Autoextend is not a feature of Tablespace, as mr. Joe Bo. says before.

you see it in DB02 ? Try to alter all datafiles from one tablespace in autoextend off mode, after

refresh all datasets in DB02 and you will see yout "tablespace' in "autoextend off mode"

if you're so easy to understand. Regards.

[Former Member]

Hi,

BR*Tool-->2.Space Management > Alter Data file> Here select option 3 - Turn on and maintain autoextend.

Thanks

Sushil

[Former Member]

In any case, you can add next datafile by switching autoextend option of the tablespace, or alter an existing datafile.

but one thing sure, after adding the datafile in autoextend off option, again you will see your corresponding tablespace in autoextend option 'ON' in DB02.

So as Sergo said, you have to set all existing datafiles of that tablespace to autoextend off, to actually see that tablespace as autoextend 'off' in DB02

[former_member343310]

So, It means, if the tablespace is created initially with autoextend off then there is no way I can switch it on ?

[Former Member]

if the tablespace is created initially with autoextend off

I don't understand how this could have happened.

Again: Autoextend is not a feature of Tablespace.

I suppose you created the first data file whith autoextend off, didn't you?

[Former Member]

Hi,

If the tablespace is created initially with autoextend off then there is a way to switch on the autoextend mode ON using BR*Tool-->2.Space Management & then select option Switch on and maintain autoextend mode.

Here you need ot give Max Size of the datafile.

Check below link for the details.

http://help.sap.com/erp2005_ehp_04/helpdata/DE/a7/8db6c2ebc5384eb82e5f99e49600d6/frameset.htm

Thanks,

Sushil

[former_member343310]

Well,

I am not asking about the Autoextend of a datafile. I already know about it.

I just need to ask if there is a way to Alter the Tablespace and switch the Autoextend feature of Tablespace.

[Former Member]

Hi,

Yes thr is way to alter the Tablespace and switch the Autoextend feature of Tablespace.

Thanks,

Sushil

[Former Member]

Autoextend is not a feature of Tablespace, but a feature of Data File.

So you cannot switch the Autoextend feature of Tablespace.

(Unless you are using BIGFILE tablespace, which is not supported by SAP.)

hope this helps

[Former Member]

Hi,

You should set all the tablespaces to be in autoextend mode, hence there are less chances of a tablespace getting full.

There are three ways to extend the tablespaces;

1. Adding a data file to a tablespace

2. Resize a datafiles

3. Change the Auto extend sizes

SAP recommendation of the datafile size for production server

Expected database size Data file size

Up to 200 GB 2 GB

200 to 400 GB 4 GB

400 to 800 GB 8 GB

Larger than 800 GB 16 GB

Also check below links

http://help.sap.com/erp2005_ehp_04/helpdata/EN/29/581630f72011d2952900a0c930df15/content.htm

http://help.sap.com/erp2005_ehp_04/helpdata/DE/a7/8db6c2ebc5384eb82e5f99e49600d6/frameset.htm

Thanks,

Sushil

[Former Member]

Use BRtools

options space management -> alter tablespace

or you can make it autoextend ON while adding datafile too, go to 'extend tablespace'

refer this link and it's sublinks/tree links

http://help.sap.com/saphelp_nw70/helpdata/en/a7/8db6c2ebc5384eb82e5f99e49600d6/content.htm