Re: Import problems after 4 GB

Because the SYSTEM tablespace is too small. Oracle tries to extend a dictionary table and it can't anymore. Either enlarge the SYSTEM tablespace, preferably by resizing the file, or allocate an extent which will fit.
You should be able to find out which object is the culprit, by enabling trace for the database or the session.

Hth,

Sybrand Bakker, Oracle DBA

Robert Nagel <nagel_at_wandrei.de> wrote in message news:7m4a72$9g6$1_at_newsread.f.de.uu.net...
> Dear Oracle-Users,
>
> I have a constant problem while importing a database of 6 GB into Oracle
> 8.0.4.0.0 : after importing about 4GB of the file he tells me (log-file)
> that the error 1658 occurred, which is something about him not being able
to
> create an "INITIAL-extent" in the tablespace "SYSTEM." Does anyone know
why
> this happens over and over again. The Oracle Server is running an WinNT 4
> SP3 with 192MB RAM and a HDD of 20 GB.
>
> thanks in advance
>
> Karsten
>
>
Received on Fri Jul 09 1999 - 03:28:24 CDT