Well, you mentioned that there were bugs:
> but there are still some nasty bugs with online index rebuilds (which is
> what this actually does) so it might be safer not do use the option for an
> IOT.
Thanks
Kumanan
> -Original Message-
> From: Jonathan Lewis [SMTP:[EMAIL PROTECTED]]
>
Thanks Jonathan.
I'm just going o test it out.
Will let you guys know if there are any positive outcomes.
Thanks
Kumanan
> -Original Message-
> From: Jonathan Lewis [SMTP:[EMAIL PROTECTED]]
> Sent: 21 March 2002 17:08
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Rebui
Many thanks to all of those people who advised.
Unfortunately we are running on 8.1.6.3, so cannot do "alter table move.. "
as well :(
If you get any info, please let me know.
Meanwhile, here are few bits that I gathered in IOTs.
Cheers
Kumanan
Why use Index-Organized Tables
* Fast key
Is that possible?
Thanks
Kumanan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
> To: Multiple recipients of list ORACLE-L
> > > > > Subject:Re: A rollback segment question on minextents
> > > > >
> > > > > [EMAIL PROTECTED] wrote:
> > > > > >
> > > > > > Hi,
> >
While on the subject..
Please see the Oracle Metalink Note: 1029850.6.
It says the first "block" of the first segment contains header
information.
> -Original Message-
> From: Kumanan Balasundaram
> Sent: 15 March 2002 17:59
> To: '[EMAIL PROTECTED]
t;
> > > > Hi,
> > > >
> > > > I was wondering why Oracle force minextents for rollback
> > > > segments to be two. Why can't we have minextents zero or
> > > > no minextents clause at all.
> > > >
> > >
.
> >
> > We can surely set initial extent to be large enough ourselves
> > and next extent sized accordingly.
> >
> > Can someone enlighten me on the reason/thought behind this?
> >
> > Many thanks
> >
> > Kumanan Balasundaram
> > Dat
ought behind this?
Many thanks
Kumanan Balasundaram
Database Administrator, IT
QXL ricardo plc
www.qxl.com
P: +44 (0)208 962 7409
> QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road,
> London W6 9EJ
> Registered in England No 3430894 VAT number - GB 701 89
5:52
> To: Kumanan Balasundaram
> Subject: Re:Reliable alerting system that is not so costly??
>
> Kumanan,
>
> Many years ago I wrote a Pro*C program to do the alerting and fixing
> for me.
> It has grown over the years and become kind of a cornerstone around her
Hi there,
Any of you using or have come across a reliable alert system that can also
escalate
to different persons based on criteria such as how important that system is?
We are looking to invest in such a software.
Kumanan Balasundaram
Database Administrator, IT
QXL ricardo plc
www.qxl.com
_files showed that it was belonging to the TOOLS tablespace.
On closer examination I discovered it had 237 SYS and SYSTEM
objects.
Another DBA must have loaded these objects in TOOLS t/s.
Recovering DB with tools and the other essentials resolved the problem.
So, watch out for this in the future.
Kuma
ntil the
> tablespace(s) to which they belong are dropped. So
> after opening the db if you attempt to access any of
> the blocks located in the omitted datafile you'll get
> an ORA-376 "datafile not available."
>
> HTH,
>
> -- Anita
>
> --- Kumanan B
e, and any tablespaces you're interested in recovering from.
> You'll also need to have a copy of a 'backup controlfile to trace' script.
> You edit that script to include on the files you're recovering and use it
> to bring up the database.
>
> Jon Walthour
> &
email message has been swept by
MIMEsweeper and Nortons Anti-Virus, for the presence of computer viruses.
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumanan Balasundaram
INET: [EMAIL PROTECTED
*******
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumanan Balasundaram
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet a
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumanan Balasundaram
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Ma
ressed. If you have received this email in error please notify
> [EMAIL PROTECTED]
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
>
his email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> [EMAIL PROTECTED]
>
> This footnote also confirms that this email message h
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumanan Balasundaram
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-
14 14 0 0 42
CLUSTER 100 99 0 0 1219
OBJECT 100 100 0 0 0
PIPE100 100 0 0 0
Thanks
Kumanan Balasundaram
Database Administrator, IT
at this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
******
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumanan Balasundaram
INET: [EMAIL PROTECTED]
Fat City Net
n swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumanan Balasundaram
INET: [EMAIL PROTECTED]
Fat City Network Services--
23 matches
Mail list logo