Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 8.1.5 import issue
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