problem by creating a view

From: Manser <nmanser_at_progis.de>
Date: 16 May 2003 11:36:44 -0700
Message-ID: <2178d61f.0305161036.952ae84@posting.google.com>

Hi oracle folks,

I am running oracle 8.1.7 on an alphaserver 1000 with OpenVMS 7.3

SQL> select tablespace_name,bytes from dba_data_files;

TABLESPACE_NAME                     BYTES
------------------------------ ----------
SYSTEM                          209715200
RMAN_TS                          20971520
RBS01                             5242880
USERS01                           2097152
TEMP01                            2097152
KLIMA                             7340032
KONTO                             2097152

7 rows selected.

SQL>
SQL> create view tablespace_alloc
  2 as select tablespace_name,bytes from dba_data_files; as select tablespace_name,bytes from dba_data_files

                                      *

ERROR at line 2:
ORA-00942: table or view does not exist

i don't understand ora-00942 , the table exists, see the query on top. can anyone tell me what's going on

thanks for any help. Received on Fri May 16 2003 - 13:36:44 CDT