Converting UNIs to PKs

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Mon, 1 Mar 2004 09:44:46 -0600
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E9374F@qtiexch2.qgraph.com>

Hey all,

Migrating from 8i to 9i, we're hoping to be able to use the expanded ONLINE features of tables, mostly for post-conversion moving of tables. I see in James Morley's outlawed paper on 9i New Features that a requirement of this is that the table must have a PK. The problem is that the DB consists of mostly vendor-created tables to support our ERP system, and none of those do not have PKs, but instead most rely on unique indexes.

As I recall, PKs are similar to UNIs, but have an additional NOT NULL constraint on the column(s). Our ERP system does not support NULLs and there are no NULLs stored (that I know of). Anyone see potential problems with adding a PK constraint to the unique indexes?

TIA,
Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA


----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Mar 01 2004 - 09:43:49 CST