Hi. I'm trying to use the DB Propagate Utility to copy a schema from my PROD DB to my TEST DB (both 8174), but after I generate the IMPACT REPORT, it give me the following error.
TABLE <schema1>.<table_name_x>: A foreign key requires the REFERENCES privilege on <schema2>.<table_name_y>.The script will not succeed when executed. Make the appropriate changes to the object and regenerate the script.
I don't realize where the error is (may be is due to some objects references another schema...) and how to solve it. Thanks in advance for any help.