How do you extend a tablespace in SAP?

How do you extend a tablespace in SAP?

Tablespace Extend with SAP BRTOOLS

1. Login to the server at OS level and change to ora user and execute command brtools.
2. Select option 2 – Space Management.
3. Select option 1 = Extend tablespace.
4. Select 3 to enter the Tablespace name.
5. Verify the tablespace name.
6. Press ‘c’ to continue.

How do I change the size of a tablespace in Oracle?

and we said…

1. alter tablespace table_space_name add datafile ‘/path/to/some/file. dbf’ size Xm; that will add a new file to the existing tablespace.
2. alter database datafile ‘/path/to/some/existing/file. dbf’ resize Xm;
3. alter database datafile ‘/path/to/some/existing/file. dbf’ autoextend on next Xm maxsize Ym;

How to fix ora-01654 unable to extend Index in tablespace?

When you get an error like: How to fix ORA-01654 unable to extend index in tablespace, then this article is for you!. The problem in Oracle is that when you delete a record, Oracle will leave it blank. That’s a real waste of space when you delete thousands of records. So deleting records will not help to solve this problem.

What does the error code ora-01654 mean?

This error code, [ORA-01654], means the server has failed to allocate an extent of the required number of blocks for an index segment in the specified tablespace.

Are there any permanent tablespaces in Oracle 9i?

There are 2 permanent tablespaces in my Oracle 9i database. One for the tables and the other for the Indexes other than the Temporary and UNDO tablespaces ORA-01654: unable to extend index by 128 in tablespace . I got the tablespace size increased considerably.

How to get rid of index in tablespace error?

In order to get rid of this error, you can simply add data file using ALTER TABLESPACE ADD DATAFILE command to the specified tablespace. First of all, you need to identify in which data file or files your index is being stored.