Home » RDBMS Server » Server Administration » Re: Altering Table
Re: Altering Table [message #374980] Tue, 17 July 2001 03:23
N.Anandasiva
Messages: 7
Registered: July 2001
Junior Member
Hi Muthu Kumar,

I feel there are some rows in ADMN_USER_LOGIN_RECORD table with company codes which are not defined in com_comany table.

Select all rows from ADMN_USER_LOGIN_RECORD table
where comp_code not defined in com_company table.

That is why the Foreing Key is not geting enabled. Import utility disables all constraints while importing the data and at the end starts enabling all constraints.

Kindly revert back to my email id.

Regrds
Shiva.
Previous Topic: Limit Function
Next Topic: Self join
Goto Forum:
  


Current Time: Sun Jul 07 16:09:02 CDT 2024