Short answer: look in the manuals. Longer answer: a LOGICAL standby database does not get updated in the same manner as a PHYSICAL standby database. Logical Standby is simply a database which is updated via SQL statements generated from the archived redo logs, not application of the archived redo logs themselves.
so you can do anything in the logical standby (including creating additional indexes on the tables from the primary database) that you can do in a regular database with the exception (from memory so this may be wrong) that the tables that are in the primary database must be read-only in the standby --- Muqthar Ahmed <[EMAIL PROTECTED]> wrote: > Juan, > > How can you create Schema in STANDBY database that does not exist in > Primiary database?????? Can you give me an example? > > Muqthar Ahmed > > -----Original Message----- > Sent: Wednesday, November 12, 2003 8:24 AM > To: Multiple recipients of list ORACLE-L > > > yes. Well documented in the manuals > > > --- Juan Miranda <[EMAIL PROTECTED]> wrote: > > > > > > Hi > > > > It is posible to create other schemas on a logical stand by > database > > ? > > > > I mean, schemas that don?t exist in the primary database. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Juan Miranda > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting > services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > __________________________________ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Muqthar Ahmed > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
