Error: table or view does not exist (due to not yet being created).

Message

Error: table or view does not exist

Cause of Error

This behavior occurs because the table, view, or synonym that you tried to use does not exist in the database.

Solution Summary

Create the table or view before you try to access it. Or, if you want to use a synonym, create the synonym first.

Solution Details

NOTE: To perform the following procedure, you must have sufficient account privileges to access the appropriate database and to create tables, views, or synonyms in the database.

1) If you have not already done so, start SQL*Plus 8.0, and then log on to the appropriate database.
2) Do one of the following as appropriate:

NOTE: Be sure to end the command with a semicolon (;).
a) Create the necessary table by typing the following command at the SQL*Plus prompt and then pressing ENTER:
CREATE TABLE (
,
,
);
where

is the name of the table you want to create, through are the names of the columns you want to create in the table, and is the datatype for a specific column.

NOTE: For some datatypes, such as CHAR, VARCHAR2, or NUMBER, you need to specify the width or precision of values. Also, you can add constraints for the table or for a specific column. For example, you can specify the primary key for the table; you can also specify the NOT NULL constraint for a column, which means that you must enter a value for that column when you add a row to the table.
b) Create the appropriate view by typing the following command and then pressing ENTER:

NOTE: To be able to create a view, you must also have sufficient account privileges to retrieve data from the table or tables you want to use in the view.
CREATE VIEW
(, ...)

AS
;
where is the name of the view that you want to create, through are the names of the columns that you want to include in the view, and is the SELECT query that retrieves data from the appropriate table or tables.
c) Create the appropriate synonym by doing one of the following:
1] To create a private synonym, type the following command, and then press ENTER:
CREATE SYNONYM
FOR .

;
where is the alternate name for the table, is the user name of the table owner, and

is the name of the table you want to create a private synonym for.
2] To create a public synonym, type the following command, and then press ENTER:

NOTE: Usually, you must have database administrator privileges to create public synonyms.
CREATE PUBLIC SYNONYM
FOR .

;
where is the alternate name for the table, is the user name of the table owner, and

is the name of the table you want to create a public synonym for.

Applies to Software Version

Oracle8