IBM Support

Sample SQL Commands to Resize OpenPages Datafiles for an Oracle Database

Troubleshooting


Problem

Administrators and/or end users are attempting to perform bullk changes (ie: FastMap loads, closing a reporting period, etc), however the system is throwing an OP-00700 type of error message. The logs are reporting: ORA-01654: Unable to extend ... in tablespace ...

Symptom

"ORA-01654: Unable to extend index %s.%s by %s in tablespace %s" in the logs

OR

"ORA-01653: Unable to extend table%s.%s by %s in tablespace %s" in the logs

In the OpenPages User Interface (UI), an administrator or end user would receive the following message:

OP-00700: The requested operation could not be complete

[{"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.3;7.2;7.1;7.0;6.2.1;6.2;6.1;6.0.1;6.0;5.5.3;5.5.2;5.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS4PJS","label":"IBM OpenPages on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1740

Document Information

Modified date:
08 May 2025

UID

swg21514218