Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PeopleSoft and Referential Integrity
On Fri, 08 Aug 1997 01:58:42 GMT, twincrk_at_ral.mindspring.com (S. Fleming) wrote:
>To be perfectly honest, I am a PeopleSoft developer with somewhat
>limited Oracle skills so I really don't know what you are asking.
>However, when you generate a SQL script from the Data Designer you get
>something like the one shown below. The only parameters that
>PeopleSoft lets you change in the Data Designer are the init and next
>sizes and the tablespace name. Those changes are saved and
>automatically placed in the script when the script is generated again.
< script snipt >
The answer is: PeopleSoft's generated DDL doesn't use declarative RI (the script used CREATE UNIQUE INDEX rather than a CONSTRAINT clause) and you can't change it to make it do so.
Phil
-- Phil Edwards phil_at_news400.com Editor, NEWS/400.uk +44 (0)161 929 0777Received on Fri Aug 08 1997 - 00:00:00 CDT