Wednesday, January 28, 2015

Oracle create table - with tablespace issue, Oracle tablespace issue, Oracle issue ora-01658

Some times while creating a table you may encounter an issue like :
ora-01658: unable to create INITIAL extent for segment in tablespace SomeTableSpace

This may be due to you not having rights on the default tablespace.
Try to find other tablespaces in the schema and modify you create table query to something like :




CREATETABLE test_a (
customer_id number(10) not null,
customer_name varchar2(50) not null,
city varchar2(50))
tablespace SomeOtherTableSpace;