Table space extension

[Former Member]

We are getting ORA-1688 error. The tablespace (PSAPSR3) shows AUTOEXTEND OFF. Though we are adding datafiles, we still get the same error. How to resolve it?

[Former Member · Accepted solution]

can you send the tablespace overview

[Former Member · Accepted solution]

---

List of tablespaces for extension

Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB]

1 - PSAPSR3 8/8 76800000 99.97 22784 76800000

2 - PSAPSR3700 7/6 21196800 90.44 2025600 63488000

3 - PSAPSR3USR 1/1 20480 3.44 19776 10240000

4 - PSAPTEMP 2/1 1638400 0.00 1638400 11264000

5 - PSAPUNDO 2/1 11182080 0.00 11181952 12492800

6 - SYSAUX 1/1 266240 95.02 13248 10240000

7 - SYSTEM 1/1 522240 98.54 7616 10240000

[Former Member · Accepted solution]

The MAXSIZE for the tablespace PSAPSR3 has reached. This is reason for your ORA Error. add a datafile to the tablespace and also increase specifiy your MAXSIZE in the same as 10 G.

You can do this through BRTOOLS.

[Former Member · Accepted solution]

check that recently added datafiles are set to autoextension on, also be sure to set the ''to be added'' datafiles to auto extn on.