Home » RDBMS Server » Server Administration » problem in tablespace
problem in tablespace [message #228094] Sat, 31 March 2007 09:52 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,
I have problem while creating table in my schema. Following is the error i am getting
ORA-01658: unable to create INITIAL extent for segment in tablespace USER

I thought initially i need to add datafile to this tablespace, then i realized enough space for this.

Then i checked dba_tablespaces for this tablespace i can see that, but i don't find this tablespace in dba_free_space.

this tablespace is locally managed.

Thanks,
Shahnaz.
Re: problem in tablespace [message #228095 is a reply to message #228094] Sat, 31 March 2007 09:57 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
ORA-01658: unable to create INITIAL extent for segment in tablespace USER

According Doc.

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

select u.bytes/1024/1024 used_mb, f.bytes/1024/1024 free_mb
from dba_data_files u , dba_free_space f
where u.tablespace_name = f.tablespace_name
and u.tablespace_name = 'USERS'
/


You should add DATAFILE for users tablespace.

Regards
Taj

[Updated on: Sat, 31 March 2007 10:01]

Report message to a moderator

Re: problem in tablespace [message #228098 is a reply to message #228095] Sat, 31 March 2007 10:54 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi Taj,
For the query you provided i don't find any record!! As i said ready i couldn't find USER tablespace in dba_free_space. But i see this tablespace in dba_data_files .

Thanks,
Shahnaz.
Re: problem in tablespace [message #228099 is a reply to message #228098] Sat, 31 March 2007 11:06 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
It is possible you don't have free space in USERS tablespace that is why you didn't see USERS tablespace in DBA_FREE_SPACE.



For the query you provided i don't find any record


Can you post exact output.

Regards
Taj
Re: problem in tablespace [message #228100 is a reply to message #228099] Sat, 31 March 2007 11:56 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Taj now i am clear in this concept, why i don't find TEMP tablespace in dba_freespace data dictioary view?
Is it again problem we need to add datafile to TEMP tablespace?

Thanks,
Shahnaz.
Re: problem in tablespace [message #228117 is a reply to message #228094] Sat, 31 March 2007 21:46 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
> why i don't find TEMP tablespace in dba_freespace data dictioary view?
1) it is DBA_FREE_SPACE not dba_freespace
2) DBA_FREE_SPACE reports for tablespaces with datafiles; not tempfiles; like TMP.
Re: problem in tablespace [message #228166 is a reply to message #228117] Sun, 01 April 2007 23:14 Go to previous message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks for your informations.
Previous Topic: EXTRACT FROM REDOLOG FILE
Next Topic: multiple instances
Goto Forum:
  


Current Time: Sat Dec 03 08:08:35 CST 2016

Total time taken to generate the page: 0.10334 seconds