Entry

while data pumping databases, constraints are not copied. so, how to make them in target database?

Jun 21st, 2005 08:18
George Boutwell, prasad,

To Add Constraints:

  ALTER TABLE <TALBE NAME> ADD CONSTRAINT <CONSTRAINT NAME> <CONSTRAINT
TYPE> <CONSTRANT OPTIONS>

  For instance

  ALTER TABLE FOO ADD CONSTRAINT FKFROMFOOTOBAR FOREIGN KEY (FIELD1)
REFERENCES BAR(FIELD1)

  Or

  ALTER TABLE FOO ADD CONSTRAINT PKFORFOO PRIMARY KEY (FIELD1)