1

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.

Kevin
  • 65
  • 1
  • 2
  • 12
  • (1) this relates to database administration so is off-topic for Stack Overflow, (2) it looks as if your tablespace has no datafiles in it. – Luke Woodward Jun 28 '14 at 16:36
  • 1
    i could resolve the issue by command -alter database datafile '\MYTBS.DBF' autoextend on; – Kevin Jun 28 '14 at 16:53

2 Answers2

10

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.

Community
  • 1
  • 1
Ajax Zhang
  • 356
  • 3
  • 12
  • 1
    The provided urls don't work for me, see http://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles003.htm#ADMIN11423 for details. – szpetip May 28 '15 at 19:05
-1

Try with the following command

alter database datafile '/somepath/somename.dbf' autoextend on maxsize unlimited;
Siyual
  • 16,415
  • 8
  • 44
  • 58
Chetan Mali
  • 11
  • 2