How can I quickly solve the foreign key constraints when the database uses truncate to clean up many tables?

Troubleshooting ideas:

1. First, set the table involved in foreign key constraints in the database to invalid.

2. After all the table data is cleared, set the table with foreign key constraints to available.

Specific implementation script:

Declare

Begin

For vv_ SQL in (SELECT 'alter table' | table_name | 'Disable constraint' | CONSTRAINT_NAME alter_ SQL FROM USER_CONSTRAINTS

Where CONSTRAINT_TYPE = 'R ')

Loop

Execute immediate vv_ SQL .alter_ SQL;

End loop;

Execute immediate 'truncate table name;

...... --- Omitted here. Multiple executesql statements can be written.

For vv_ SQL in (SELECT 'alter table' | table_name | 'Enable constraint' | CONSTRAINT_NAME alter_ SQL FROM USER_CONSTRAINTS

Where CONSTRAINT_TYPE = 'R ')

Loop

Execute immediate vv_ SQL .alter_ SQL;

End loop;

End;

/