Gilroy Maynard Lobo, March 31, 2021 - 5:59 am UTC
I can use Data Pump, But does it take care of the thing that i have mentioned schemaname.tablename in procedures.
See i have those schemas, i am moving 2,3 & 4 to schemaall, after that 2,3 & 4 will be removed.
Now my concern is there are some procedures in my schema1 which used to do some DML in tables of 2, 3 & 4. For ex We had used schema2.tablename. Now since i am moving to schemaall i want it to be replaced with schemaall.tablename
April 12, 2021 - 5:23 am UTC
But is there any significant issue that is forcing you to do that?
Why consolidate?