table or view does not exist
when i chek the dulicate key for the table SAPUSER
following error comes out.
Details are the followings
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\prdadm>cd\
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Oct 6 12:08:34 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> conn /as sysdba
SQL> select alldata.rowid, alldata.*
2 from sapuser alldata,
3 (SELECT K_COL1, K_COL2
4 FROM sapuser GROUP BY K_COL1, K_COL1
5 HAVING COUNT(*) > 1) keydata
6 where alldata.K_COL1=keydata.K_COL1
7 and alldata.K_COL2=keydata.K_COL2;
FROM sapuser GROUP BY K_COL1, K_COL1
ERROR at line 4:
ORA-00942: table or view does not exist
please advise whre we are wrong.
with best reagrds
Debasis Sahoo replied
As Lars has already explained the access to the table SAPUSER is not granted from SYS, as it is not owned by sys but by OPS$ user. sqlplus / is the easiest way to do this.
But however if you're logged in <sid>adm and through connect / as sysdba, then you can also use the below statement to access SAPUSER.
SQL> select * from "OPS$<host>\<sid>ADM".SAPUSER;
hope this helps.