When i create any table in my schema an error occurs : ORA-01658: unable to create INITIAL extent for segment in tablespace OWAPUBHow to overcome of it?

Interview Candidate
Sep 15th, 2006
4
2747

Showing Answers 1 - 4 of 4 Answers

madhu sudhan rao

Sep 18th, 2006

Create table privilege is not granted
in order to grant create table privilege, connect to sys/manager and then type grant create table to <username>

sisindia

Jun 7th, 2007

hi to all sql lovers

the answer is-

unable to create initial extent for segment in such table space

failed to find sufficient contiguous space to allocate initial extent for segment being created

use ALTER TABLESPACE ADD DATAFILE to add additional space to the table space or retry with a smaller value for INITIAL

Atul Singh