Re: Import Problem!!!

This means TEMP is full and/or doesn't have sufficient free CONTIGUOUS space to allocate the requested amount of bytes. Apart from the fact that your output of dba_tablespaces is not readable, it is the wrong dictionary view for this purpose. You need to look at dba_free_space where tablespace_name = 'TEMP'

HTH, Sybrand Bakker, Oracle DBA

<lkj741_at_my-deja.com> wrote in message news:8abe9r$pvr$1_at_nnrp1.deja.com...
> when I was importing my dmp file for a user in a user_table that
> I created in the new database I'm getting this error massage.
>
> IMP-00003: ORACLE error 1658 encountered
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> TEMP
>
> Also in my alart log I'm getting this error
>
> ORA-1652: unable to extend temp segment by 46080 in tablespace
> TEMP
>
>
> SVRMGR> select * from dba_tablespaces;
> TABLESPACE_NAME INITIAL_EX NEXT_EXTEN MIN_EXTENT
> MAX_EXTENT PCT_INCREA MIN_EXTLEN STATUS CONTENTS LOGGING
> ------------------------------ ---------- ---------- ---------- --------
> -- ---------- ---------- --------- --------- ---------
> SYSTEM 10240 10240 1
> 121 50 0 ONLINE PERMANENT LOGGING
> RBS 131072 131072 2
> 121 0 0 ONLINE PERMANENT LOGGING
> TEMP 83886080 94371840 1
> 2147483645 0 0 ONLINE TEMPORARY LOGGING
> TOOLS 10240 10240 1
> 121 50 0 ONLINE PERMANENT LOGGING
> USERS 10240 10240 1
> 121 50 0 ONLINE PERMANENT LOGGING
> xxrops 10240 10240 1
> 121 50 0 ONLINE PERMANENT LOGGING
> xxxxxxx 10240 10240 1
> 121 50 0 ONLINE PERMANENT LOGGING
> xxxxxx 10240 10240 1
> 121 50 0 ONLINE PERMANENT LOGGING
> xxxxxx 10240 10240 1
> 121 50 0 ONLINE PERMANENT LOGGING
> xxxxx 10240 10240 1
> 121 50 0 ONLINE PERMANENT LOGGING
> 10 rows selected.
>
> Please give me your input.
>
> Thanks
> Ashadul.
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 10 2000 - 12:51:58 CST