| unable to create initial extents [message #62319] |
Wed, 14 July 2004 04:21  |
BhavinShah
Messages: 105
Registered: February 2004
|
Senior Member |
|
|
hi,
friends
I have prob. when i am creating a table from another's schema.
I am getting this error when i am creating a table:
SQL>create table month_close as (select * from rjyjun.month_close where 1=2);
ORA-01658: unable to create INITIAL extent for segment in tablespace IMMS
Initial extent size in table is 586M :
SQL> SELECT INITIAL_EXTENT FROM user_segments
2 where segment_name like 'MONTH_CLOSE';
INITIAL_EXTENT
--------------
586211328
space in tablespace imms is around 2gb.
1 select tablespace_name,sum(bytes)/1024/1024 from dba_free_space
2 where tablespace_name='IMMS'
3* group by tablespace_name
SQL> /
TABLESPACE_NAME SUM(BYTES)/1024/1024
------------------------------ --------------------
IMMS 2344.05273
Kindly give me the best solution and reason of this problem.. it's seems to urgent for me..
thax to all
bye..
bhavin
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
