In JUnit, foreign keys are generally not required. However, the foreign key has been created during the database generation process, which is troublesome for adding, deleting, and modifying data. Follow these steps to invalidate or take effect of the foreign key as needed.
Run the following SQL
SELECT 'alter table' | TABLE_NAME | ''|
'Disable constraint' | CONSTRAINT_NAME | ';'
FROM USER_CONSTRAINTS
WHERE CONSTRAINT_NAME LIKE 'sys % 'AND
CONSTRAINT_TYPE = 'R ';
Several SQL statements similar to the following are generated.
Alter table ACCOUNT_PORTFOLIO disable CONSTRAINT SYS_C001219591;
Copy all generated statements to the text editor. If there is no problem, copy them directly to SQL plus for execution, and all foreign keys can be shielded.
In addition, if you execute the following SQL
SELECT 'alter table' | TABLE_NAME | ''|
'Enable constraint' | CONSTRAINT_NAME | ';'
FROM USER_CONSTRAINTS
WHERE CONSTRAINT_NAME LIKE 'sys % 'AND
CONSTRAINT_TYPE = 'R ';
Execute the generated SQL statement to make the foreign key take effect.