SQL Error: ORA-01653: unable to extend table SYSADM.PS_UC_TSK_CNT_BKP by 8 in tablespace RBLARGE
01653. 00000 - "unable to extend table %s.%s by %s in tablespace %s"
Solution is :-
First check
select * from dba_tablespaces where tablespace_name='RBLARGE';
Second :-
SELECT * FROM dba_data_files WHERE TABLESPACE_NAME='RBLARGE';
Then at last run
alter database datafile '/oradata22/cmact/data/rblarge.dbf' AUTOEXTEND ON NEXT 104857600 MAXSIZE 4000M;
Issue will be Fixed :)
01653. 00000 - "unable to extend table %s.%s by %s in tablespace %s"
Solution is :-
First check
select * from dba_tablespaces where tablespace_name='RBLARGE';
Second :-
SELECT * FROM dba_data_files WHERE TABLESPACE_NAME='RBLARGE';
Then at last run
alter database datafile '/oradata22/cmact/data/rblarge.dbf' AUTOEXTEND ON NEXT 104857600 MAXSIZE 4000M;
Issue will be Fixed :)
No comments:
Post a Comment