Hi All,
Oracle 19c
Suppose, we want to copy the HR user in the same dabase with different schema name. The problem is when we copy the schema, it points the same table with HR. For example triggers which belong to HR are remaped to HR_COPY schema. So, the schema name has been changed. However, the table inside that triggers still point the HR table right? So, after you import the schema then errors can be occur because both triggers point the same table. Can't we also remap the schema table to HR_COPY in the triggers? Can't we remap all objects inside packages, views, etc to HR_COPY?
What do you recommend for these kind of problems?
REMAP_SCHEMA=HR:HR_COPY
Thanks in advance