OraFAQ Forum: Server Administration » uable to create INITIAL extent for segment in tablespace PREMIA.

Home » RDBMS Server » Server Administration » uable to create INITIAL extent for segment in tablespace PREMIA. (Oracle 10g, windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

uable to create INITIAL extent for segment in tablespace PREMIA. [message #418308]

Fri, 14 August 2009 00:49

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

While importing dump i am getting the error "uable to create INITIAL extent for segment in tablespace PREMIA". Though I have created tablespace PREMIA.
Below is my script-

CREATE TABLESPACE PREMIA DATAFILE 'C:\ORACLE\ORADATA\PREMIA.DBF' SIZE 4000M
;

How to rectify this problem?

waiting for your prompt reply...

Thanks

Attachment: initial segment.GIF
(Size: 143.63KB, Downloaded 740 times)

[Updated on: Fri, 14 August 2009 00:58]

Report message to a moderator

Re: uable to create INITIAL extent for segment in tablespace PREMIA. [message #418309 is a reply to message #418308]

Fri, 14 August 2009 01:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ It is not "uable" bot "unable", this error would have not happened if you use copy and paste.

2/ It is not on CREATE TABLESPACE but on CREATE INDEX, same remark.

Next time COPY AND PASTE do not post a screen shot, this has been requested many times.

Regards
Michel

Report message to a moderator

Re: uable to create INITIAL extent for segment in tablespace PREMIA. [message #418315 is a reply to message #418309]

Fri, 14 August 2009 02:33

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Did you actually look up what the error means before you posted here?

Quote:

ORA-01658:
unable to create INITIAL extent for segment in tablespace string
Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.
Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL

Basically, you need to add more space to your tablespace.

Report message to a moderator

Previous Topic:	Where can I find a sample of dbca.rsp file?
Next Topic:	Error in alert log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 17:32:14 CST 2024