cancel
Showing results for 
Search instead for 
Did you mean: 

Extending Table Space

Former Member
0 Kudos
345

We have a production business warehouse system (SAPPLB) and I was wondering about something regarding table space.

First off we have an issue cause the table space always is high so I have to always use BRTools to extend the table space. I usually check the space in BW and then I determine whether to extend table space or not.

I hate having to do this manually, isnt there something that allows for auto extending a table space rather than manually running brtools and extending tablespace? I am a SQL Server expert and new to SAP and Oracle and am just wondering if there is any "auto extend" capability with this.

In SQL Server I can specify that a database autoextend on its own without me having to extend the table space. Is this possible in Oracle / SAP.

Thanks,

Jon

View Entire Topic
former_member204746
Active Contributor
0 Kudos

when you create a datafile, you can ask it to autoextend by itself. this can even be changed after datafile is already created.

check this command:

brspace -c -u / -f dfalter

choose option 3

Former Member
0 Kudos

or you can activate AUTOEXTEND for an existing data file like that or with brtools.

<b><i>ALTER DATABASE DATAFILE '<path_and_name>' AUTOEXTEND ON</i></b>;