Successfully installed Oracle 21c database and now I am moving all my data from 11g to the new database. I created all my tables in the “USERS” tablespace and when I attempt to insert data into the tables I get the error “ORA-01950: no privileges on tablespace 'USERS'”, so I granted unlimited tablespace to the use with the command “ALTER USER <username> GRANT UNLIMITED TABLESPACE ON tablespace USERS;” and “ALTER USER <username> quota UNLIMITED on users;”. Yet again, when I attempt to insert data into the table I still get “ORA-01950: no privileges on tablespace 'USERS'”, so assuming the user didn't have INSERT permissions on table I executed the command “GRANT INSERT ANY TABLE TO <username>;”, and still get the same error when insert data to the table. Is there some sort of restriction on the tablespace that won't all me to insert data to a table created in the USERS tablespace? I believe I granted all the necessary permissions.
This is the exact text of the error:
Insert into <schema Name>.COUNTRIES (COUNTRY) values ('Afghanistan')
Error at Command Line : 261 Column : 28 File @ C:\Data\DataScript.sql
Error report -
SQL Error: ORA-01950: no privileges on tablespace 'USERS'
This script creates the tables and then attempts to insert the data. I'm use Sql Developer to run the script. I used Sql Developer to generate the script from the 11g database. The tables are created successfully, but the inserts fail.