8.1.5 import issue

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 - 03:37:52 CDT