2017-02-09 12:02:00
Topic starter
Notifications
Clear all
Developer Network Q&A
1
Posts
1
Users
0
Reactions
1,837
Views
0
While building a platform instance, Oracle gave me this error:
ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128 in tablespace SYSTEM
How do I solve it?
1 Answer
0
2017-02-09 12:02:00
Topic starter
- Login to Oracle in sqlplus or sqldeveloper as "system"
- Execute the following query to find out which datafile is hosting the tablespace in question. (In the error above, it's the "SYSTEM" tablespace.)
select file_name from dba_data_files where tablespace_name = 'SYSTEM'; - Once you have that filename, execute the following, replacing my filename with yours:
alter database datafile 'E:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' autoextend on maxsize unlimited;
