Re: ORA-01547 failed to allocate extent
From: Chris Little <chris.little_at_cho.ge.com>
Date: 1996/04/30
Message-ID: <3186890A.7D5A_at_cho.ge.com>#1/1
Date: 1996/04/30
Message-ID: <3186890A.7D5A_at_cho.ge.com>#1/1
> >Have created another tablespace for temp segments, done the ADD
> >DATAFILE, and done all that the manuals suggest for defragmenting.
> >Exported data, dropped and recreated table and re-imported data and
> >this worked for about a day and a half. PLEASE HELP ME. Oracle Helpdesk
> >was not speaking my language. Error occurs when doing a table update.
> >Error indicates Failing to Allocate Extents. Using WARP Connect and
> >Oracle version 7.
> >Any advice would be greatly appreciated.
> Another possibility is that the table is fine, but one of its indexes
can't be extended. I've seen DBA's scratching their heads on this one
for hours. The error doesn't discriminate between table and index.
Good luck.
Chris
-- Chris Little, Oracle DBA & SAP Basis GE Fanuc Automation N. America, Inc. Phone: 804.978.5945 Fax: 978.6942 E_mail: chris.little_at_cho.ge.comReceived on Tue Apr 30 1996 - 00:00:00 CEST