Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Does Every Table Need a Primary Key for Data Guard (Physical Standby)?

Re: Does Every Table Need a Primary Key for Data Guard (Physical Standby)?

From: HansF <News.Hans_at_telus.net>
Date: Thu, 07 Apr 2005 15:30:27 GMT
Message-Id: <pan.2005.04.07.16.32.21.833412@telus.net>


On Thu, 07 Apr 2005 07:57:09 -0700, GeoPappas interested us by writing:

> I read that every table in a Data Guard (Logical Standby) needs to have
> a primary key. Is this also true for a Data Guard (Physical Standby)?
>

Physical Data Guard ships archive logs. Logical Data Guard ships streams extracted from logs by key.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***
Received on Thu Apr 07 2005 - 10:30:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US