how can i increase tablespace. i am working on oracle 10G

[Former Member]

one of table space is going to fill now it is looking 95% used. how can i increase it...

[Former Member · Accepted solution]

You may use one of the following option :

1 You can add data file

2 You can alter one of the current data file

3 you can set autoextend ON (make sure you have enough space in that drive/partition)

check

[http://help.sap.com/saphelp_nw70/helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm]

[Former Member · Accepted solution]

Dear Manoj

how can i add new table either tell me how can autoexten on

[Former Member · Accepted solution]

Follow the steps mentioned in the link below.

[http://help.sap.com/saphelp_nw70/helpdata/en/f1/5e863f06593a17e10000000a114084/content.htm]

[fidel_vales · Accepted solution]

>

> Dear Manoj 
> how can i add new table either tell me how can autoexten on

Strongly recommend to get some Oracle training if you have to do increase a tablespace and you have no clue how to do so

www.sap.com/education

www.oracle.com/education

[Former Member · Accepted solution]

hi manoj

should we take any precaution before increasing the table size

[Former Member · Accepted solution]

should we take any precaution before increasing the table size

Generally, you should make sure that you are adding the datafile at correct location and of appropriate size. Based on the current growth you should add the file in correct location otherwise you might end up moving files from one location to another location or adding more files frequently. Regularly monitoring the folder free space if autoextend is on and so on.

[Former Member]

helpfull

[Former Member]

Hi

i am trying to increasing size throw brspace..it is not inceasing .

Can you post the error log here

Regards

Uday

[Former Member]

Hi

should we take any precaution before increasing the table size

If you are unable to add datafiles to tablespace because of filleup tablespace size then you can do that

Did you try adding datafiles to tablespace ?

Regards

Uday

[Former Member]

hi uday

i am trying to increasing size throw brspace..it is not inceasing .

[Former Member]

Hi Azeem,

Increasing the tablespace needs some expertise at the database level even though we have a menu driven tool called BRTools.

Using the BRTools u can increase the tablespace with ease.

Excute brtools at the OS level (command prompt), make sure that u have logged in as ORA<SID> or <SID>adm and proceed as follows

brtools --> 2 - Space management --> 1 = Extend tablespace --> c(ontinue) --> c(ontinue) --> 1 = Extend tablespace --> Select the required tablespace and then proceed accordingly.

You have to ensure that there is enough space available in the disk before u start extending the tablespace. Else the brspace program will fail.

Regards,

Varadhu

[Former Member]

Hi,

Check below links

http://help.sap.com/saphelp_nw70/helpdata/EN/a7/8db6c2ebc5384eb82e5f99e49600d6/frameset.htm

Hope it helps

Thanks

Sushil

[Former Member]

HI Azeem

Check this [Blog|;

Regards

Uday