Six Stars

ORA-01950: no privileges on tablespace

Hello ,

 

I am getting this error while migrating hadoop to Oracle

i have granted the user dba and still the error comes up.

it was throwing out errors on USERS tablespace but i dropped the table space to for it  to use its own default tablespace, the error has moved to POC tablespace .

I have defined a default tablespace for the schema but it tends to connect to POC

on what do i need to do to fix it, 

 

 

[statistics] connecting to socket on port 3863
[statistics] connected
ORA-01950: no privileges on tablespace 'POC'
[ERROR]: sandbox_leapoc_project.fw_leapoc_0_1.FW_LEAPOC - talendStats_DB - ORA-01950: no privileges on tablespace 'POC'

 

  • Big Data
  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Employee

Re: ORA-01950: no privileges on tablespace

Hi

 

This is related to the AMC configuration since it is referring to  talendStats_DB.  Are you using a different schema or Oracle User for the AMC config?  Check either in your Project properties or your jobs context if you have contextualise the AMC tables.

2 REPLIES
Employee

Re: ORA-01950: no privileges on tablespace

Hi

 

This is related to the AMC configuration since it is referring to  talendStats_DB.  Are you using a different schema or Oracle User for the AMC config?  Check either in your Project properties or your jobs context if you have contextualise the AMC tables.

Six Stars

Re: ORA-01950: no privileges on tablespace

Thank you , this solved the issue, i gave user AMC  unlimited quota on the tablespace and job is running now.