Solution steps.
SQL> show user;
USER is "APPS"
SQL>GRANT execute ON APPS.FND_FILE TO cust_schema;
SQL> show user;
USER is "cust_schema"
SQL>
SQL> CREATE OR REPLACE SYNONYM FND_FILE FOR APPS.FND_FILE;
Synonym created.
I hope issue has been resolved.
Solution steps.
SQL> show user;
USER is "APPS"
SQL>GRANT execute ON APPS.FND_FILE TO cust_schema;
SQL> show user;
USER is "cust_schema"
SQL>
SQL> CREATE OR REPLACE SYNONYM FND_FILE FOR APPS.FND_FILE;
Synonym created.
How to find the size of schema in the 23AI ORACLE Database. SQL> select sum(bytes)/1024/1024 "SIZE_IN_MB" from dba_segments;...