Home » RDBMS Server » Server Utilities » Constraints
Constraints [message #73570] Tue, 25 May 2004 03:34
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Dear Friends,

The problem that i am facing is like this,I have two databases, from one database I am taking an Export and Importing in other database.During Import i get a problem due to constraints.The import is succesful only when I use Constraints=N parameter.
But,how do i get the constraints of 1st database into 2nd database.
Can any body tell me that If there is any script or procedure which when executed can give me create or alter table statments for creating constraints of the 1st database so that I can create those constraints after Import into 2nd database or any other way through which I can disable the constraints at database level during Import so that I dont have to specify Constraints=N parameter and Enable the constraints once the Import is over.

Kindly help me on this.

Milind.
Previous Topic: Import
Next Topic: IMPORT
Goto Forum:
  


Current Time: Mon Jul 01 15:56:41 CDT 2024