Re: RMAN impact
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: "Mark Brinsmead" <pythianbrinsmead@xxxxxxxxx>
- Date: Mon, 30 Oct 2006 10:38:46 -0700
On 10/28/06, Mark Brinsmead <pythianbrinsmead@xxxxxxxxx> wrote:
Nonetheless, I'll stick to my original statement; if you find an Oracle
database containing a large number of tables with no indexes, somebody
usually deserves a kick in the butt. (That said, in my wanderings, I have
actually encountered more than a few databases containing hundreds or tables
with nary a Primary Key constraint in sight. Of course, had it actually
been in my power, I probably would have kicked some butts -- I have yet to
encounter a situation where that lack of primary keys was actually correct
-- although I can imagine a few where it would be...)
Some apps do their own PK enforcement.
Though a number of apps do this, the only one I have personally seen that
does so succesfully is SAP. I still don't like it, but there's little I can
do about it.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
- References:
- Re: RMAN impact
- From: Mark Brinsmead
- RE: RMAN impact
- From: Tanel Poder
- Re: RMAN impact
- From: Mark Brinsmead
Other related posts:
- » RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » re: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » RE: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
- » Re: RMAN impact
Nonetheless, I'll stick to my original statement; if you find an Oracle database containing a large number of tables with no indexes, somebody usually deserves a kick in the butt. (That said, in my wanderings, I have actually encountered more than a few databases containing hundreds or tables with nary a Primary Key constraint in sight. Of course, had it actually been in my power, I probably would have kicked some butts -- I have yet to encounter a situation where that lack of primary keys was actually correct -- although I can imagine a few where it would be...)
Some apps do their own PK enforcement.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
- Re: RMAN impact
- From: Mark Brinsmead
- RE: RMAN impact
- From: Tanel Poder
- Re: RMAN impact
- From: Mark Brinsmead