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

1
votes

I got message on Oracle when creating schema:

ORA-01658: Unable to create INITIAL extent for segment in tablespace using application.

I have searched to solve this issue, but it is still not working.

Anyone have the same problem?

1
oracleoracle10gschematablespace
Possible duplicate of ORA-01658: unable to create INITIAL extent for segment in tablespace TS_DATA - APC

1 Answers

1
votes

You need to have the DBA privileges to resolve this problem.

See the Oracle forum discussion.

  1. extend the datafile to add space (ALTER DATABASE DATAFILE <name> RESIZE <new size>)

  2. add a new datafile to the tablespace (ALTER TABLESPACE <tablespace name> ADD DATAFILE <datafile name>