Re: cannot create view of rm_text_lines in Process Modeller

Try to login with SQL*Plus as JETHRO and use this statement:

  CREATE VIEW JED( TEXT, ID )
  AS ( SELECT TXT_TEXT, TXT_REF FROM RM_TEXT_LINES ); Then you can create any synonym to this VIEW and grant privileges...

I hope this will help you.

eschen42_at_my-dejanews.com wrote:
>
> We are running designer 2000 version 2.1
> (The repository is a database that is on a server running Oracle 8.0.4 for NT)
>
> I want to create a view of the RM_TEXT_LINES table.
> Any ideas why SQL*PLUS won't let me :( ?
>
> Here's a transcript of my SQL*PLUS session:
>
> SQL> ;
> 1 CREATE VIEW JED( TEXT, ID )
> 2* AS ( SELECT TXT_TEXT, TXT_REF FROM JETHRO.RM_TEXT_LINES )
> SQL> /
> AS ( SELECT TXT_TEXT, TXT_REF FROM JETHRO.RM_TEXT_LINES )
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
>
> SQL> DESC JETHRO.RM_TEXT_LINES
> Name Null? Type
> ------------------------------- -------- ----
> TXT_REF NOT NULL NUMBER(38)
> TXT_SEQ NOT NULL NUMBER(6)
> TXT_TYPE NOT NULL VARCHAR2(10)
> TXT_TEXT VARCHAR2(2000)
> TXT_NOTM NUMBER(38)
>
> SQL> SELECT * FROM user_synonyms
> 2 WHERE SYNONYM_NAME = 'RM_TEXT_LINES';
>
> SYNONYM_NAME TABLE_OWNER
> ------------------------------ -------------
> TABLE_NAME
> ------------------------------
> DB_LINK
> --------------------------------------------
> RM_TEXT_LINES JETHRO
> RM_TEXT_LINES
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
http://www.dd.ru