| Re: Error when trying to use DB scripts provided with OTM I am able to get past the tablespace creation step now.
However, when I get to the step to create_public_synonyms, I receive the following error:
SQL> @create_public_synonyms
SELECT owner, table_owner FROM DBA_SYNONYMS WHERE SYNONYM_NAME = p_synonym_name;
*
ERROR at line 8:
ORA-06550: line 8, column 35:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 8, column 4:
PL/SQL: SQL Statement ignored
I am logged in as glogowner as per the admin guide while running this script. the previous 2 scripts in this section ran without error. |