How to Alter Tablepsace

[sivakumar_kilari3]

Hi,

How to autoextended off using brtools.

Is it possible autoextended off tablespaces?

please guide me.

Thanks & Regards

siva

[Former Member · Accepted solution]

Hi,

Yeah you can alter tablespace using BRTOOLS:

in brtools go to Space management-> alter tablespace.

And it is possible to turn off the autoextend for tablespace.

You can do it using alter tablespace.

Regards,

payal

[Former Member · Accepted solution]

Hi Payel ,

What i think the alter table space as you mentioned contains only the options

(online|offline|begback|endback|coalesce) in the Alter Tablespase Action. So this can be used to take Tbsp offline or online or begin bkup or end bkup or Collasce.

So how to turn the auto extension off?

How ever there is a option to turn off auto extension off for a data file vide the option Alter Data File.

Regards

[Former Member · Accepted solution]

Hi Manas,

Yeah you right.

It was my mistake.

Autoextend function is at data file level not at tablespace level.

Siva: pls ignore my reply.

Regards,

Payal

[Former Member · Accepted solution]

Hi,

Its Ok pl dont mind.

For Siva.

If this is verymuch necessary you can do so from SQL level.

Shut down the db then execute the folllowing from cmd line

sqlplus /nolog

connect /as sysdba;

startup mount;

alter tablspace <tblspacename> autoextend off;

Regards

[sivakumar_kilari3 · Accepted solution]

Thanks Manas,

Good Answer

Siva