Error 1270

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

Item Description

SQLCode

-1270L

Constant

NO_PERMS_FOR_IMV

SQLState

42WD3

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2957

Severity Code

16

Parameter 1

The name of the table

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com