Hi,
I am going to import data from database A into database B.Both dbs have the same table definitions. I just need the data from db A to db B. I know that I have to disable the constraints on the tables before I import data into the tables. But I have about 180 tables. Is there a script which can automatically generate another script which I can use to disable the constraints and enable them when I finish importing. It would take forever to disable them manually. I would appreciate if somebody can help.
Thanks in advance.