Technical Notes
We're all on the same page!
Useful shortcuts for vi editor
Friday 3 November 2017
ORA-01950 Solution
Action
SQL> CREATE TABLE HR2.EMPLOYEES_NEW AS SELECT * FROM HR.EMPLOYEES;
Error
ORA-01950: no privileges on tablespace 'USERS'
Solution I
SQL> ALTER USER HR2
QUOTA 1024M ON
USERS:
Solution II
SQL> GRANT
UNLIMITED TABLESPACE TO
HR2;
Newer Post
Older Post
Home