error code 1356 - invalid table/view
Posted by:
BN Vo
Date: October 15, 2007 11:06AM
hi,
I have a problem to open and/or describe table. The errors I had are
mysql_stgssl>desc ATL1_USER_DETAILS_VW;
ERROR 1356 (HY000): View 'atl1.ATL1_USER_DETAILS_VW' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
mysql_stgssl>select * from ATL1_USER_DETAILS_VW;
ERROR 1356 (HY000): View 'atl1.ATL1_USER_DETAILS_VW' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
mysql_stgssl>
How can see who own the table? Can someone show me how to pull the data dictionaries chart for MySQL??? I used to select table_name, owner from dba_tables in Oracle but I don't know how to do it in MySQL
Thanks,
bvo
Subject
Views
Written By
Posted
error code 1356 - invalid table/view
26770
October 15, 2007 11:06AM
10822
December 23, 2007 12:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.