Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 8.1.5 import issue

Re: 8.1.5 import issue

From: Alistair Thomson <alistair_at_despammed.com>
Date: Wed, 8 Oct 2003 11:38:06 +0100
Message-ID: <bm0pee$s7k$1$830fa17d@news.demon.co.uk>


Tom

If you have access to metalink check out document id 1014040.102 If not send me an email and I will send you the contents. It sorts your problem.

Alistair

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:1065602338.83554.0_at_eunomia.uk.clara.net...
> Hi,
>
> I'm upgrading from 8.1.5 to 9.2.0.4 and having an issue.
>
> Duing the upgrade process i am cleaning out lots of cruddy data - to do
this i want to test my scripts first.
>
> I export the user from the current 8.1.5 system into a test 8.1.5 system
but during the import of a big table with lots of BLOB's i
> get the
>
> ORA-01691: unable to extend lob segment XXXX.SYS_LOB0000003195C00003$$ by
106709 in tablespace XXXX
>
> this tablespace currently has 4 datafiles associated with it that are all
max sized to 1GIG and initial size of 10M with a 10M next
> segment.
>
> This is the state of the datafiles for the whole instance after the
attempted import...
>
> $ du -sk /u02/oradata/XXXX/*
> 10256 /u02/oradata/XXXX/indx01_SOL.dbf
> 348352 /u02/oradata/XXXX/main01_SOL.dbf
> 502024 /u02/oradata/XXXX/main02_SOL.dbf
> 1048408 /u02/oradata/XXXX/main03_SOL.dbf
> 430312 /u02/oradata/XXXXmain04_SOL.dbf
> 5136 /u02/oradata/XXXX/oemrep01_SOL.dbf
> 46384 /u02/oradata/XXXX/rbs01_SOL.dbf
> 512 /u02/oradata/XXXX/redo04.log
> 179304 /u02/oradata/XXXX/system01_SOL.dbf
> 27784 /u02/oradata/XXXX/temp01_SOL.dbf
> 10256 /u02/oradata/XXXX/users01_SOL.dbf
> 10256 /u02/oradata/XXXX/users02_SOL.dbf
> 10256 /u02/oradata/XXXX/users03_SOL.dbf
> 10256 /u02/oradata/XXXX/users04_SOL.dbf
>
> does anyone know why this would fail as there is enough 'free' space in
the tablespace.
>
> thanks
>
> Tom
>
>
Received on Wed Oct 08 2003 - 05:38:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US