ORA-01658: unable to create INITIAL extent for segment in tablespace USERS

When do we get this error?

When tablespace doesn't have good enough space,will receive ORA-01658 error.

Where do we trace this error?

We can trace the error from alert log. Read the alert log using tail unix command.

How to fix it ?

Solution:

Find the disk usage for free space and add datafile for the tablespace.

SQL>alter tablespace USERS add datafile '/oradata/prod/users02.dbf' size 100m autoextend on maxsize unlimited;

Following error found when importing data from dumpfile

DW00 started with pid=51, OS id=5961, wid=1, job SYSTEM.SYS_IMPORT_SCHEMA_01
Tue Sep 01 09:02:47 2020
statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_01.1' was suspended due to
ORA-01658: unable to create INITIAL extent for segment in tablespace USERS

After Adding datafile,the job auto resumed as follows.

Tue Aug 01 09:11:15 2019
alter tablespace users add datafile '/u01/app/oracle/oradata/users02.dbf' size 100m autoextend on maxsize unlimited
Completed: alter tablespace users add datafile '/u01/app/oracle/oradata/users02.dbf' size 100m autoextend on maxsize unlimited
Tue Sep 01 09:11:18 2020
statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_01.1' was resumed