This content has been marked as final. Show 4 replies
SSU wrote:Did you mean two SCHEMAs or tow databases?
I have a 2 test oracle databases and each of them contain a table called department (dept_no,dept_name, main_dept_no) where each department entry is connected to main department by dept_no in the MAIN_DEPT_NO column.
Please post DB version.
The exact error message you are getting.
output of the below from the DB rom where you are getting the error
I have 2 computers which running 2 same databases with same schemas.
The version of databases is given below.
1.Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production
2.PL/SQL Release 18.104.22.168.0 - Production
3.CORE 22.214.171.124.0 Production
4.TNS for Linux: Version 126.96.36.199.0 - Production
5.NLSRTL Version 188.8.131.52.0 - Production
Error is ORA-00904 DEPT_NO invalid identifier.