| problem in tablespace [message #228094] |
Sat, 31 March 2007 09:52  |
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  |
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 |
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 #228100 is a reply to message #228099] |
Sat, 31 March 2007 11:56 |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
