Wednesday 1 April 2015

ORA-01653: unable to extend table SYSADM.PS_UC_TSK_CNT_BKP by 8

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 :)

No comments:

Post a Comment

The purge process did not run because the Oprid configured to start the Process Scheduler did not have the required permissions to run the purge process.

  Purge process - Required permissions The PeopleSoft Oprid used to start the Process Scheduler, as defined in the Scheduler's psprcs.cf...