Sunday, January 9, 2011

ORA-01536:space quota exceeded for tablespace PSAPEWP

Question:
We get the following error during the dataload and the import of
transports in system EWP:

00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                BY  L
Database error 1536 requires database administrator to intervene
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                BY  4
Database error 1536 at INS access to table RSBATCHCTR
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                BY  0 >
ORA-01536: space quota exceeded for tablespace 'PSAPEWP'
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                AB  0
Run-time error "DBIF_RSQL_SQL_ERROR" occurred
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                AB  1 >
Short dump "101230 000204 lux01317_EWP_00 ALEREMOTE " created
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                D0  1
Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR )


We can't find any change of database users in the alertlog. The error
occured in two systems.


We checked note 644104 - ORA-01536 / ORA-01950 but all users are
configured correctly with the UNLIMITED_TABLESPACE privilege.


Please assist.

Answer:
Looking at your description, you had granted unlimited tablespace
privilage to user according to note 644104 and still having error
ORA-01536.


This issue probably just DBA role to Oracle user was assigned to SAP
system and then again redrawn.


Ensure SAPDBA and SAPCONN role is assigned, could you please check on
note #834917 Oracle Database 10g: New database role SAPCONN


Here are some articles from Metalink which describe this error:
Revoking DBA or RESOURCE Privilege Revokes UNLIMITED TABLESPACE from the
 User [ID 1084014.6]

All About Security: User, Privilege, Role, SYSDBA, O/S Authentication,
Audit, Encryption, OLS, Database Vault, Audit Vault [ID 207959.1]

ORA-01536, when enough space is available [ID 270582.1]

To access to Oracle Metalink, refer to note #758563 Oracle Metalink
access for SAP customers

No comments:

Post a Comment