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