Order Processing Fails With TABLESPACE Privileges Issue " SQL Exception ORA-01950: no privileges on tablespace 'LARGE_DATA'" (Doc ID 2058054.1)

Last updated on MARCH 20, 2023

Applies to:

Goal

 Order processing failed with following errors:

<20-Sep-2015 3:07:12,182 IST AM> <WARN> <dataaccesslayer.AbstractProxy> <[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'> <SQL Exception ORA-01950: no privileges on tablespace 'LARGE_DATA'
ORA-06512: at "ORDERMGMT.OM_REM_ATTACH_PKG", line 25
ORA-06512: at line 1
: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'LARGE_DATA'
ORA-06512: at "ORDERMGMT.OM_REM_ATTACH_PKG", line 25
ORA-06512: at line 1
>
<Sep 20, 2015 3:07:12 AM IST> <Warning> <oms> <BEA-000000> <dataaccesslayer.AbstractProxy: SQL Exception ORA-01950: no privileges on tablespace 'LARGE_DATA'
ORA-06512: at "ORDERMGMT.OM_REM_ATTACH_PKG", line 25
ORA-06512: at line 1
: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'LARGE_DATA'
ORA-06512: at "ORDERMGMT.OM_REM_ATTACH_PKG", line 25
ORA-06512: at line 1
>

and

Caused by: com.mslv.oms.automation.OrderUpdateException: Error updating order data: orderId[51620] orderHistId[1118]
at com.mslv.oms.automation.TaskContextLocal.updateOrderDataDom(TaskContextLocal.java:281)
at sun.reflect.GeneratedMethodAccessor1013.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at net.sf.saxon.functions.ExtensionFunctionCall.invokeMethod(ExtensionFunctionCall.java:690)
at net.sf.saxon.functions.ExtensionFunctionCall.call(ExtensionFunctionCall.java:343)
... 35 more
Caused by: com.mslv.oms.handler.OrderUpdateFailedException: ORA-01950: no privileges on tablespace 'LARGE_INDEX'
ORA-06512: at "ORDERMGMT.OM_ORD_INST_PKG", line 1981
ORA-06512: at "ORDERMGMT.OM_ORD_INST_PKG", line 1389
ORA-06512: at "ORDERMGMT.OM_ORD_INST_PKG", line 1100
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 2034
ORA-06512: at line 1

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.