Re: Oracle error 1658

Hi,

    You don't have enough contiguous free space in the tablespace you want to use to contain an additional extent. You may have run out of space, in which case just add an additional datafile to the tablespace and try again, or the tablespaced may be fragmented. (It may have enough free space, but it may be scattered around the tablespace with no one chunk of free space big enough to hold your additional data.) If this is so you have three things you can try: first try to coalesce the tablespace which may or may not help. If you don't want to spend time doing something which may or may not work you have two choices. If you have enough total free space in the tablespace you can consolidate the contents of the tablespace by exporting and importing all of the tables it contains. You can also add a datafile.

regards

Jerry Gitomer

Johnson Huang wrote in message <7kak7v$fsl_at_netnews.hinet.net>...
>Dear all,
> When I import data, and then I encountered the oracle error 1658,
>and I know it means that cannot create INITIAL space, and it want me use
>smaller INITIAL space, I just want to know what the cause?
>
>
Received on Thu Jun 17 1999 - 12:16:05 CDT