Re: Indexes and Maxextents

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 25 Sep 1998 12:51:46 GMT
Message-ID: <361691c9.151732720@192.86.155.100>

A copy of this was sent to stuco_at_mailcity.com (if that email address didn't require changing) On Thu, 24 Sep 1998 20:56:41 GMT, you wrote:

>Question: If I reach the MAXEXTENTS limit on one of my indexes, will the data
> in my table still get loaded?
>

no, if the index cannot be maintained for a row being inserted, the row is rejected with an error.

>If so: Will the index continue to get built after I free the index from
> it's error, OR will my index need to get totally rebuilt??
>
>Very interested in the answer to that one.
>
>Stuart Cowen
>Paladin Consulting - Dallas
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Sep 25 1998 - 07:51:46 CDT