Wednesday, January 27, 2016

ORA 01950 no privileges on tablespace

Saved

Record Not Saved to DataBase ORA-01950: no privileges on tablespace 'USR'

ORA-06512: at "LDBO.SP_SCHEDULERSETUP", line 735

sb17271112
E:\ldoutput



SYS@FWS1213> grant unlimited tablespace to ldbo;

Grant succeeded.

SYS@FWS1213>  ALTER USER LDBO QUOTA UNLIMITED on USR;

User altered.

SYS@FWS1213>
SYS@FWS1213> ALTER USER LDBO QUOTA UNLIMITED on INDX;



ALTER USER LDBO QUOTA UNLIMITED on USR;

ALTER USER LDBO QUOTA UNLIMITED on INDX;

grant unlimited tablespace TO LDBO;



Select Tablespace_Name, Username, Bytes / 1024 / 1024/ 1024 "Used GB", Max_Bytes / 1024 / 1024/ 1024 As "Max GB"  from dba_ts_quotas;


select file_name,tablespace_name,bytes/1024/1024 "Size MB",status,autoextensible,maxbytes/1024/1024 "MaxSize MB",Increment_By from dba_data_files;






No comments:

Post a Comment

Followers