>A Basic Qs. On Logical standby mode - Dataguard - >9.2.0.4 . Is the >following statement correct ? > >>From the Primary Database the DMLs on tables NOT >having LONG columns are >successfully applied across to the=20 > >Logical Standby database while those tables >containing LONG columns fail > >Query to find Objects which are NOT supported ;- > >Select * from DBA_LOGSTDBY_UNSUPPORTED; >
I have done a number of tests for a customer, although I cannot *swear* I was on 9.2.0.4. All I can say is that, trying to see how things were going on when doing an import, I exported data I didn't know. As it happened, they were LONG columns in it - and I was unaware of it. So, yes, indeed it failed. Not systematically though, since some tables went through. And no, nothing was listed in DBA_LOGSTDBY_UNSUPPORTED. And I also find the statement according to which everything goes well if there is no LONG a tad optimistic, because even with a nominally 'safe' set of data to replicate I had ORA-00600 errors. Looks interesting, promising - and totally immature. The lack of proper monitoring facility is scary (very difficult to say when and why something goes wrong - and you see it at only one end, not both). Except for tests, I shall wait for a stable 10g before playing with logical standby databases again. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).