cancel
Showing results for 
Search instead for 
Did you mean: 

Can we increase table size?

former_member222931
Participant
0 Kudos

Hi Experts,

From my knowledge and understanding, we can increase size of a tablespace.

Can we increase size of a particular table? If so, how can we do it from brtools?

Appreciate your advice.

Thanks.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Why do you want to increase the size of table when it's gets increased as needed automatically by oracle?

former_member222931
Participant
0 Kudos

Hi,

Thank you Manoj Chintawar and Lars Breddemann..

The reason I ask is because the functional consultant in my company is having problem regarding their PR workflow. The are claiming that the size of a table (called EBAN) should to be increased to resolve the error.

From my understanding, tablespace size can be increase by adding data file.I have not heard of increasing table size..

So,that is the reason I post my question here.

Thank you for the feedback..

markus_doehr2
Active Contributor
0 Kudos

> The reason I ask is because the functional consultant in my company is having problem regarding their PR workflow. The are claiming that the size of a table (called EBAN) should to be increased to resolve the error.

If you get the exact error/dump we can certainly give a suggestion

Markus

former_member204746
Active Contributor
0 Kudos

you need to increase tablespace. you can do this by extending an existing datafile:

brspace -c -u / -f dfalter

or, you add a datafile:

brspace -c -u / -f tsextend

as stated by everyone else, you cannot extend a table as per se.

0 Kudos

>

> The reason I ask is because the functional consultant in my company is having problem regarding their PR workflow. The are claiming that the size of a table (called EBAN) should to be increased to resolve the error.

Actualy, I cannot think of any "problem" that can be solved increasing a table size.

I'm really curious to know the problem.

could you explain it here in detail?

former_member220071
Active Participant
0 Kudos

Hi Shafinaz

Try following , hope it will help you.

1.If yours is unix login as ora<SID> and type brtools at command prompt.

2.in the menu select 2,space management

3.in the next menu select 1.extend table space

3.In the next menu select 3,tablespace name and it prompts for the name and type tablename.

4.CONTINUE

5.CONTINUE

6.you will get the following screen.

Options for extension of tablespace tablename (1. file)

1 * Last added file name (lastfile) ....... [/oracle/CRD/sapdata2/undo_1/undo.d

ata1]

2 * Last added file size in MB (lastsize) . 6800

3 - New file to be added (file) ........... [/oracle/CRD/sapdata2/undo_2/undo.d

ata2]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... 6800

6 - File autoextend mode (autoextend) ..... no

7 # Maximum file size in MB (maxsize) ..... 10000

8 # File increment size in MB (incrsize) .. 20

9 - SQL command (command) ................. [alter tablespace tablename add data

file '/oracle/CRD/sapdata2/undo_2/undo.data2' size 6800M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

7.choose 5 if you want to specify size of Datafile.Also check whether enough space is available at OS level to add this datafile.(use df -k "path of directoy" to check space

8.click on continueand it will take few minutes to add the datafile and your tablespace is now extended!

You can execute this when SAP is Up and running,no need to stop SAP or DB.

Abhijeet

lbreddemann
Active Contributor
0 Kudos

Shafinaz asked about increasing the space for a table not for a tablespace.

Your solution will only enlarge a tablespace.

regards,

Lars

lbreddemann
Active Contributor
0 Kudos

> Can we increase size of a particular table? If so, how can we do it from brtools?

Hi there,

the table size is automatically increased by Oracle when more space is required.

Anyhow, if you feel that one table should allocated more space than necessary, you can run


ALTER TABLE <table_name> ALLOCATE EXTENT;

Since this is usually not a sensible action, this isn't supported by the BR*Tools.

regards,

Lars