- 论坛徽章:
- 0
|
有谁能帮我看看如下出错代码是什么原因造成的:
-206 The specified table <table-name>; is not in the database.
The database sever cannot find a table or view specified in the statement.The table or view might have been renamed or dropped from the database.
You might also get this message if you omit the keyword "TYPE" when you are trying to grant USAGE privileges on a user-defined.For example,the following GRANT statement is correct:
GRANT USAGE ON TYPE person_row_type TO usr2;
The following GRANT statement,howerve,generates error -206:
GRANT USAGE ON person_row_type TO usr2;
Check the names of tables and views in the statement or check for omission of the keyword "TYPE" in a GRANT statement.If the names are spelled as you intended and "TYPE" is not missing,check that you are using the database you want.Tofind the names of all tables in the database,query the systables table.To find the names of all views,query the sysviews table. |
|