RE: providing 24*7 database ---

2001-10-24 Thread Aponte, Tony
Title: RE: providing 24*7 database --- Narender hasn't replied yet.  But the sample I sent only uses local indexes since there is only one partition.  I did see that Jim Conboy pointed out that I missed the 'including indexes' option. Tony -Original Message

RE: providing 24*7 database ---

2001-10-24 Thread Cherie_Machler
et> cc: Sent by: Subject: RE: providing 24*7 database ---

RE: providing 24*7 database ---

2001-10-24 Thread Jim Conboy
L PROTECTED]]Sent: Tuesday, October 23, 2001 10:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: providing 24*7 database --- Thanks all for the input. hi tony , Quick question ... when you exchange partititons with non partitioned table data , all indexes on non partition

RE: providing 24*7 database ---

2001-10-24 Thread Aponte, Tony
Title: RE: providing 24*7 database --- I couldn't verify that the non-partitioned indexes become unusable after exchanging the partition for the normal table.  In the sample I posted I snipped the output of the queries on USER_INDEXES and USER_PART_INDEXES, but my tests showed that

RE: providing 24*7 database ---

2001-10-23 Thread Narender Akula
Title: RE: providing 24*7 database --- Thanks all for the input. hi tony , Quick question ... when you exchange partititons with non partitioned table data , all indexes on non partitioned tables become unusable status right. do have to rebuild them after every exchnage...   naren

RE: providing 24*7 database ---

2001-10-22 Thread Jared . Still
Sent by: Subject: RE: providing 24*7 database --- [EMAIL PROTECTED]

RE: providing 24*7 database ---

2001-10-22 Thread Aponte, Tony
Title: RE: providing 24*7 database --- We use a modified version of your duplicate schema idea.  But we don't have the objects in different schemas.  We use partitioned objects so that we can exchange the partitions with the production tables at a scheduled time.  The voodoo is that we

RE: providing 24*7 database ---

2001-10-19 Thread Nick Wagner
Title: RE: providing 24*7 database --- Here is a link http://www.quest.com/whitepapers/ you can use to check out a couple of white papers on 24x7 shops and HA environments with Oracle.   One very good one, that will help address your needs is this one... http://www.quest.com/whitepapers

RE: providing 24*7 database ---

2001-10-19 Thread Rachel Carmichael
Having been through (and still going through this)... we use one for queries, one for loading, when the loads are done, we do a backup then we switch the app to the "loading" database (coded so that as long as someone is connected the app doesn't switch over). once the app has switched, we down

RE: providing 24*7 database ---

2001-10-19 Thread Guy Hammond
The thing that immediately springs to mind would be to use two databases, one for queries, one for loading. Then, when the data was ready, use a transportable tablespace to plug it in. There might be some post processing or redefining of views necessary. This is better than using two schemas to do

RE: providing 24*7 database ---

2001-10-18 Thread Jack C. Applewhite
Narender, Transportable Tablespaces might allow you to load data in an offline instance then quickly "plug in" the new data to the production instance. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iN

RE: providing 24*7 database ---

2001-10-18 Thread Baker, Barbara
Tim Gorman's paper "Choosing Among High-Availability Architectures in Oracle" at www.evdbt.com/library.htm might be useful. He lists options available and relative costs. Good luck! Barb > -- > From: Narender Akula[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTE