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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s