When ORA-01654 happened, It is due to the tablespace is not enough.
So, you can set the tablespace to autoextensibe, and create a new datafile for the tablespace.
1.check your tablespace autoextensible
2. Alter database datafile autoextend
3.Alter tablespace to add a new datafile
Size unit is MB
So, you can set the tablespace to autoextensibe, and create a new datafile for the tablespace.
1.check your tablespace autoextensible
Select tablespace_name , autoextensible from dba_data_files;
2. Alter database datafile autoextend
Alter database datafile '' autoextend on maxsize 10000M;
3.Alter tablespace to add a new datafile
Alter tablespace add datafile '' size 1000M ;
Size unit is MB
留言