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

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 7 Apr 2005 17:14:11 +0200
Message-ID: <d33io2$qf8$1@nntp.fujitsu-siemens.com>

"GeoPappas" <PappasG_at_gmail.com> schrieb im Newsbeitrag news:1112885829.801264.40670_at_z14g2000cwz.googlegroups.com...
> 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)?
>
> FYI: Using 10gR1 on Solaris 2.9

No. Physical standby operates very different. There are absolutely no constraints apart from the obvious physical ones (sufficient disk space, same dbversion and so on).
Logical standby is IMHO unusable for reliability, it is primarily meant as a form of replication in order to run reports and stuff on the logical standby.

Lots of Greetings!
Volker Received on Thu Apr 07 2005 - 10:14:11 CDT