-
Code:
SQL> create synonym xx for th.ddf;
Synonym created.
SQL> select * from xx;
select * from xx
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid
Abhay is correct.
-
ok thats true, but if you to desc xx you get a different message 'object th.dff does not exist'
Which is still actually different than ORA-00942 so I gues the OP either had the user there or gave us the wrong error message as Abhay said
Last edited by davey23uk; 12-09-2003 at 08:22 AM.
-
Originally posted by davey23uk
not true ...
Code:
[oracle@cim4 oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Dec 9 11:48:49 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production
SQL> create public synonym emp_v for blah.emp;
Synonym created.
SQL> select username from dba_users;
USERNAME
------------------------------
SYS
SYSTEM
OUTLN
MZADMIN
DBSNMP
Wass not true...& i have no clue why you have posted the part of the code?
Did i ever tell, its not possible to create a synonym for NON existent object??
Well, i said the error he is getting is not what he shud have GOT, if he is getting that error then there should be some user by the TPYO and table/view by that name and no privs for user querying for that synonym...
Is ther any thing where i am not being logical in my approch??
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by Thomasps
Code:
SQL> create synonym xx for th.ddf;
Synonym created.
SQL> select * from xx;
select * from xx
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid
Abhay is correct.
I Dont had any user by name BALKE....
You get "ORA-00942: table or view does not exist"
when u create a PUBLIC synonym
create public synonym xxx for th.ddf
SELECT * FROM XXX
ORA-00942: table or view does not exist
-
Wass not true...& i have no clue why you have posted the part of the code?
Did i ever tell, its not possible to create a synonym for NON existent object??
Well, i said the error he is getting is not what he shud have GOT, if he is getting that error then there should be some user by the TPYO and table/view by that name and no privs for user querying for that synonym...
Is ther any thing where i am not being logical in my approch??
Abhay.
thats why I corrected myself after - i apologise
-
Originally posted by bang_dba
I Dont had any user by name BALKE....
You get "ORA-00942: table or view does not exist"
when u create a PUBLIC synonym
create public synonym xxx for th.ddf
SELECT * FROM XXX
ORA-00942: table or view does not exist
Yes indeed on 8.x it throws this misleading error. But 9.x no probs, the error is relevent.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|