ora-1658: unable to creat initial extent for segment in tablespace

sql database oracle oracle11g oracle-xe
Kevin picture Kevin · Jun 28, 2014 · Viewed 35.2k times · Source

i'm getting the error "ora-1658: unable to create initial extent for segment in tablespace MYTBS" when trying to import a dump using imp command.i'm using oracle XE 11.2 in a standalone windows machine. database backup is around 200MB. following is my table space setup.enter image description here

how can i correct this error? schema that i'm trying to import has tables defined for tables space MYTBS.

Answer

Ajax Zhang picture Ajax Zhang · Dec 18, 2014

The error should

ora-01658 unable to create initial extent for segment in tablespace ????

to solve the problem:

You will need an account with DBA privileges to do one of two things , and link

  1. extend the datafile to add space (ALTER DATABASE DATAFILE RESIZE ) , or autoextend (ALTER DATABASE DATAFILE autoextend on) Changing Datafile Size

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

And if your datafile has been reached 32GB , please refer to this answer.

Related questions

Oracle SQL query for Date format

I always get confused with date format in ORACLE SQL query and spend minutes together to google, Can someone explain me the simplest way to tackle when we have different format of date in database table ? for instance i have …

Read More
Oracle - How to create a materialized view with FAST REFRESH and JOINS

So I'm pretty sure Oracle supports this, so I have no idea what I'm doing wrong. This code works: CREATE MATERIALIZED VIEW MV_Test NOLOGGING CACHE BUILD IMMEDIATE REFRESH FAST ON COMMIT AS SELECT V.* FROM TPM_PROJECTVERSION V; If …

Read More
copy from one database to another using oracle sql developer - connection failed

I am trying to copy a table from one database to another using oracle sql developer. I have the username, password and SIDs. copy from uname1/password1@SID1 to uname2/pwd2@SID2 insert table1 (*) using (select * from message_table); However …

Read More