cannot create view of rm_text_lines in Process Modeller

From: <eschen42_at_my-dejanews.com>
Date: Tue, 10 Nov 1998 20:48:38 GMT
Message-ID: <72a8r6$3ij$1_at_nnrp1.dejanews.com>

[Quoted] 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 Received on Tue Nov 10 1998 - 21:48:38 CET