Designer/2000 1.3.2 : RM_TEXT_LINES
Date: Tue, 28 Mar 2000 16:49:26 +0200
Message-ID: <8bqequ$a8t$1_at_news1.xs4all.nl>
Hi all,
A few days ago we imported a Designer repository drom one of our sister-companies but when the users tried to connect to it the following error text appeared:
RME-02124: Failed to execute SQL statement: select txt_type, txt_text from
RM_TEXT_LINES T where txt_seq = (select min(txt_seq) from cdi_text where
txt_ref = T.txt_ref and txt_type = T.txt_type) and txt_ref = :B1 order by
txt_type
RME-02123: Failed to parse SQL statement
ORA-00942: table or view does not exist
Somehow the object RM_TEXT_LINES could not be found even though I did create and reconcile the new users. As a 'solution' I created a public synonym RM_TEXT_FILES for the object CDI_TEXT and that seemed to do the trick. But now I'm curious if that was the right thing to do or if this can really harm the repository. In that case: what should I do.
tia,
B.J. Meinders
Oracle DBA
ASR-ICT
Received on Tue Mar 28 2000 - 16:49:26 CEST