ORA-01950: no privileges on tablespace 'USERS'

  Insert into coretoebs_process_info (PROCESS_NAME,HOST_NAME,PORT_NAME,ACTIVE,CREATE_DATE,REQUEST_TYPE,PROTOCOL) values ('UpdateCRMProjectToEBS','soaapp01.rosendin.com',7001,'N',to_date('03-OCT-16','DD-MON-RR'),'POST','HTTP/1.1')

Error report -

ORA-01950: no privileges on tablespace 'USER


Fix:


SQL> ALTER USER apps_bpel QUOTA 100M ON USERS;


User altered.


SQL> GRANT UNLIMITED TABLESPACE TO apps_bpel;


Grant succeeded.


Comments

Post a Comment

Popular posts from this blog

org.apache.poi.POIXMLException:+org.apache.poi.openxml4j.exceptions.InvalidFormatException" Error When Creating WebADI Documents

 while creating WebADI documents, getting following error org.apache.poi.POIXMLException:+org.apache.poi.openxml4j.exceptions.InvalidFormatException Oracle Note: "org.apache.poi.POIXMLException:+org.apache.poi.openxml4j.exceptions.InvalidFormatException" Error When Creating WebADI Documents (Doc ID 2495167.1) Cause:  WebADI_Template.xlsm template file got corrupted Fix: Copy the  WebADI_Template.xlsm template file from working environment.   strings -a $BNE_TOP/patch/115/bneobjects/WebADI_Template.xlsm|grep Header ls -lrt $BNE_TOP/patch/115/bneobjects/WebADI_Template.xlsm cd $BNE_TOP/patch/115/bneobjects/ cp -rp WebADI_Template.xlsm WebADI_Template.xlsm_orig mv WebADI_Template.xlsm WebADI_Template.xlsm_BKP cp -rp /applprd/software/OAuth/UIapps_steps/WebADI_Template.xlsm .   ls -lrt WebADI_Template.xlsm chmod 755 WebADI_Template.xlsm ls -lrt WebADI_Template.xlsm
Read more

adop UNEXPECTED Unable to find appltop_id for host ebsapp2 in database

error: Validating system setup.     Node registry is valid.     [UNEXPECTED]Unable to find appltop_id for host ebsapp2 in database     [UNEXPECTED]Unable to find appltop_id for host ebsapp2 in database cause: on node2  s_atName parameter value having wrong entryu on node1 grep -i s_atname $CONTEXT_FILE          <APPL_TOP_NAME oa_var="s_atName">AT_ebsapp1</APPL_TOP_NAME> [appr12prd@esbapp1:R12PRD:scripts] [appr12prd@ebsapp2:R12PRD:~] > grep -i s_atname $CONTEXT_FILE          <APPL_TOP_NAME oa_var="s_atName">ebsapp1</APPL_TOP_NAME>  === wrong entry on node2 , it should be AT_ebsapp1 reference: ADOP Phase=prepare Fails With the Error "[UNEXPECTED]Unable To Find Appltop_id For Host In Database" (Doc ID 2794402.1) Fix:  s_atName parameter value in node1 and node2 should be same as  AT_ebsapp1 as node2 is having wrong entry ,  updated it with correct value and...
Read more