Technical Notes
We're all on the same page!
Useful shortcuts for vi editor
Showing posts with label
ORA-01950
.
Show all posts
Showing posts with label
ORA-01950
.
Show all posts
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;
Older Posts
Home
Subscribe to:
Posts (Atom)