Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

Must own table '%1' in order to make an immediate view reference it

Error constant SQLE_NO_PERMS_FOR_IMV
ODBC 2 State ERROR
ODBC 3 State ERROR
Parameter 1 The name of the table
Severity 16
SQLCODE –1270
SQLSTATE 42WD3
Sybase error code 13754
Probable cause

You have attempted to change the refresh type of a materialized view to immediate and the view references a table that is not owned by you. In order to perform this operation, you must either own all the tables referenced by the materialized view or have DBA privileges.