Need to change schema name change during export and import
Hi,
I have to design a Development database and a production database. Now, we are planning to create an users HISPROD,CISPROD for production database and HISPPR,CISPPR for development database which is the exact replica of HISPROD and CISPROD respectively of production. We have many procedures in HISPROD which uses internal query such as "select * from CISPROD.my_table",etc. Now we have to take export of this schema HISPROD and import it to HISPPR of development database. But I think the internal codes of the procedure will not change (i.e. CISPROD.my_table will remain the same in HISPPR in Development database). I want to
I have to design a Development database and a production database. Now, we are planning to create an users HISPROD,CISPROD for production database and HISPPR,CISPPR for development database which is the exact replica of HISPROD and CISPROD respectively of production. We have many procedures in HISPROD which uses internal query such as "select * from CISPROD.my_table",etc. Now we have to take export of this schema HISPROD and import it to HISPPR of development database. But I think the internal codes of the procedure will not change (i.e. CISPROD.my_table will remain the same in HISPPR in Development database). I want to
0