ORA-01658:unable to create INITIAL extent for segment

system · June 3, 2015, 12:15pm

Hi,

There are 27 SAP tables and there is need to extract all in oracle 11g database.
The job initially gave the error ‘ORA-01658:unable to create INITIAL extent for segment in tablespace XXX’
DBA set the size by 500 MB. It ran fine but again it gave the error.

Any idea on the permanent solution on this?

Is there any standard good tablespace size to be set at oracle

its_ranjan (BOB member since 2011-02-16)

system · June 3, 2015, 3:53pm

It needs to be sized to whatever your data needs are.

If you are constrained on space then consider enabling compression on the tables and then be sure you use a direct path load method (bulk load).

eganjp (BOB member since 2007-09-12)