Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> import problems Solaris 8 and 8.1.7 - urgent
Tom,
Does the tablespace have 'lots of free space' in one chunk, or in lots ? If you are not using Locally Managed Tablespaces, then the INITIAL and NEXT requirements of any object must be provided from a single contiguous chunk of free space. Your import bombed out requesting 138 MB (roughly) and in a non-LMT this has to be from one single bit of free space.
Check out the space you have by using :
select tablespace_name, sum(bytes)/1024/1024 as total_free_mb, count(*) as fragments, max(bytes)/1024/1024 as biggest_bit from dba_free_space group by tablespace_name;
If you find that the biggest bit is smaller than the size requested by your import, then that is your problem. You might find that ALTER TABLESPACE XXXXXX COALESCE will combine enough separate free bits into one - but then you might just get one extra extent added before it goes to pot again.
On the other hand, assuming that there is space in a single chunk, and that that bit of space is bigger than what you need, then what is the PCTINCREASE setting for the tablespace. If this is not zero, then what is being reported in the error message is the size that the import requested, but Oracle may be trying to allocate a HUGE chunkl of NEXT extent due to (a) the PCTINCREASE settiing and (b) the current NEXT extent number - it quickly goes ballistic as extents are added. Trust me, I've been there and I know ! (Always a good example for trainee DBAs - why is there 250 MB of contiguous free space in that tablespace yet this table cannot allocate a NEXT extent of 64 KB ?)
One word of warning, I've got absolutely no experience with LOBs - so the above may not apply. :o)
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Tom [mailto:tomNOSPAM_at_teameazyriders.com]
Posted At: Wednesday, December 04, 2002 1:28 PM
Posted To: server
Conversation: import problems Solaris 8 and 8.1.7 - urgent
Subject: import problems Solaris 8 and 8.1.7 - urgent
Hi,
I'm trying to import a databaseas in an earlier post. I noticed one of
the
tables was empty when it imported overnight.
I have tried to imp this table by itself and its pretty big and takes
anout
2 hours. About 3 quarters of the way through it fails and rolls back,
hence
no rows, with the following error.
IMP-00058: ORACLE error 1691 encountered
ORA-01691: unable to extend lob segment XXXXXX.SYS_LOB0000003331C00002$$
by
138254 in tablespace XXXXXXX
IMP-00028: partial import of previous table rolled back: 1628 rows
rolled
back
BUT there is tons of room in that tablespace - it spans 12 datafiles
that
are set yo be autoextend to a max size of a gig each.
the listing of the datafiles is as follows....
bash-2.03$ du -sk *
235656 blob01_SOL.dbf 358592 blob02_SOL.dbf 512272 blob03_SOL.dbf 758152 blob04_SOL.dbf 768392 blob05_SOL.dbf 30752 blob06_SOL.dbf 30752 blob07_SOL.dbf 51248 blob08_SOL.dbf 71736 blob09_SOL.dbf 112712 blob10_SOL.dbf 163936 blob11_SOL.dbf 245896 blob12_SOL.dbf
any help appreciated
thanks
Tom Received on Wed Dec 04 2002 - 07:56:46 CST