View Single Post
  #4 (permalink)  
Old July 6th, 2009, 14:37
cspadola cspadola is offline
Senior Member
 
Join Date: Feb 2008
Posts: 114
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 13
Thanked 1 Time in 1 Post
Rep Power: 3
cspadola is on a distinguished road
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.