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?
Asked
Active
Viewed 7,721 times
1
APC
- 144,005
- 19
- 170
- 281
user3354967
- 37
- 1
- 4
-
1Possible duplicate of [ORA-01658: unable to create INITIAL extent for segment in tablespace TS\_DATA](http://stackoverflow.com/questions/37071152/ora-01658-unable-to-create-initial-extent-for-segment-in-tablespace-ts-data) – APC Mar 02 '17 at 08:03
1 Answers
1
You need to have the DBA privileges to resolve this problem.
See the Oracle forum discussion.
extend the datafile to add space (
ALTER DATABASE DATAFILE <name> RESIZE <new size>)add a new datafile to the tablespace
(ALTER TABLESPACE <tablespace name> ADD DATAFILE <datafile name>
Rahul Tripathi
- 168,305
- 31
- 280
- 331
-
Thanks Rahul, for your information we have set when CREATE TABLESPACE and DATAFILE we set AUTOEXTEND. Is it we still need to RESIZE the DATAFILE and TABLESPACE ? – user3354967 Jan 08 '16 at 08:40
-