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