I want to load some of the tables with a new set of Data but some of the interdependent constraints does not allow me to do so.
I want to disable all the constraints for the tables,then load the data and enable all the constraints back.
Can someone help me out with possible guidance on this.

There is a cross referencing data in my DB.Foreign Key of table1 refers to primary Key of Table B and Foreigh key of Table B refers to Primary Key of Table A.Like this there are around set of 50 tables that have an inter cross referencing so I want to disable the constraints,Load all the tables and enables the constraints back.

so I want to disable the constraints,Load all the tables and enables the constraints back.

It is still not at all clear why you want to load "corrupt" data. . .

Why do you want to load data that does not meet "the rules"? Either the constraints are valid and must be met or they should be modified/removed. You might use a few "catch all" values so the constraints would be met and change/corrent them later.

There is a situation where we have 100 tables and 5000 constraints.Not sure on how to handle this kind of situation while uploading the data.So thought the best way is to disable the constraints,upload the data and enable it back.

By Handling I mean to say that how do I insert data in all the tables maintaining referential integrity.As soon as I start the process of deletion of data from these table it says integrity violation.
We can handle this for small number of tables by emptying the foreign table first and then emptying the primary table and inserting records in the primart table first and then the foreign tables.

Thanks for your advice.Do you mean to say we have to set Integrity OFF for that table first.Could you please elaborate on how to use Enforce No option?
If Enforce No would stop the table from the constraint chcking while loading then we can select all the 100 tables and start the deletion/loading process right?

It has been a while since I've done this, so you'll have to try my solution if it still works.

So If I remember correctly :

LOAD REPLACE ENFORCE NO will put your table and its children in check pending. (it doesn't check the RI)

CHECK DATA can read other tables that are check pending, so you don't need to to force other tables first.

If you have circular RI (or cross RI) at least one of the RI will be SET NULL.
f.e. :
A-> restrict -> B
B-> set null -> A

The table B with the set null will come out of check pending.
if check table A doesn't find errors , table A will also come out of check pending.
if check table A finds errors (and removes rows) , table B will go back into checkpending.

If you repeat it, in the end all tables will come out of checkpending.

Thanks a lot for your suggestion.
I have checked with the ENFORCE NO Option and this works!.

The only problem I have is now how to set my Check Data.This utility need the tablespace names for the tables so how do I pull out thetablespace name each time.
Could you please guide me on the Check Data utility since we do not have options to create the Exception table.