CODEWITHSUNDEEP
sqldatabaseoracle-databaseoracle11goracle-xe
Kevin
Kevin

Reputation: 85

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

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.

Upvotes: 1

Views: 40974

Answers (3)

GaneshMuni
GaneshMuni

Reputation: 51

Get Tablespace Details:

SELECT * FROM dba_tablespaces;

Get Datafile location for respective user:

SELECT * FROM dba_data_files;

Add another Datafile to the user, increasing the overall space: Code:

ALTER TABLESPACE <tablespace_name> 
ADD DATAFILE <'new_datafile_location'>
SIZE <Size>;

Example:

ALTER TABLESPACE USERS 
ADD DATAFILE '/home/oracle/oracle_home/ora19c/oradata/ARESDB/users03.dbf' 
SIZE 3000M;

Upvotes: 0

Chetan Mali
Chetan Mali

Reputation: 11

Try with the following command

alter database datafile '/somepath/somename.dbf' autoextend on maxsize unlimited;

Upvotes: -1

Ajax Zhang
Ajax Zhang

Reputation: 356

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.

Upvotes: 10

Related Questions