on 05-08-2009 8:30 AM
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.
Why do you want to increase the size of table when it's gets increased as needed automatically by oracle?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
>
> 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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.