Search This Blog

Monday, November 11, 2013

ORA-01653: unable to extend table * by 128 in tablespace

Error occurs because given table space size is not enough to grow. This can use to increase or decrease the table spaces 

log in to the database as sysdba

[oracle@ovmclipdb datafile clipdb]$ sqlplus / as sysdba

Alter database with a new size

SQL> alter database datafile 'datafile_name' RESIZE new_size;

 SQL>commit;


To select the datafile location use below command.

SQL>  select NAME from v$datafile;




No comments:

Post a Comment