ORA-01658: unable to create INITIAL extent for segment in tablespace USERS
Error:
kIsH@Xhydra<>begin
2 for i in 1 .. 1000 loop
3 insert into partition values (i,i,to_date(trunc(dbms_random.value(to_char(date '1979-01-01','J'),to_char(date '9999-12-31','J'))),'J'),'a');
4 end loop;
5 commit;
6 end;
7 /
begin
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace USERS
ORA-06512: at line 3
kIsH@Xhydra<>!oerr ora 1658
01658, 00000, "unable to create INITIAL extent for segment in tablespace %s"
// *Cause: Failed to find sufficient contiguous space to allocate INITIAL
// extent for segment being created.
// *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
// tablespace or retry with a smaller value for INITIAL
AlPhAGEeK369 