Author |
Message |
mmx
Joined: 05 Dec 2006 Posts: 8
|
|
BUG. Version 1.0.47 BETA |
|
Oracle 10g.
At serial input assistent can't find element in the list.
Sample.
vms_univers - not found whereas he is on the list.
|
|
Tue Dec 05, 2006 5:03 am |
![ICQ Number ICQ Number](templates/GreenTech/images/lang_english/icon_icq.gif) |
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Could you please provide more details? It is not clear what you wanted to say
What is "vms_univers?" Is that a table, column, package, procedure, function, mat view, synonym? In which case it cannot be found? in which part of SQL command? What type of editor?
|
|
Tue Dec 05, 2006 9:00 am |
|
![](templates/GreenTech/images/spacer.gif) |
mmx
Joined: 05 Dec 2006 Posts: 8
|
|
|
|
vms_univers - view
Editor - TOAD 8.5 - it matters ?
part of SQL command - select * from ????
others SQL commands not test.
vms_univers - object is in the objects lists.
|
|
Tue Dec 05, 2006 10:57 am |
![ICQ Number ICQ Number](templates/GreenTech/images/lang_english/icon_icq.gif) |
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
I guess you are simply connecting SQL Assistant to a different database. Please check if you have multiple Oracle clients installed on your computer. In client settings you likely have same TNS names but pointing to different databases, as a result in Toad you connect to a database where the mentioned view is present and in SQL Assistant you connect to a database where it is not.
If my guess is correct, please update your TNSNAMES.ORA files and make them point to the same database.
|
|
Tue Dec 05, 2006 1:24 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mmx
Joined: 05 Dec 2006 Posts: 8
|
|
|
|
I have one oracle client. i'm verify.
My tnsnames.ora:
# tnsnames.ora Network Configuration File: D:\Oracle\product\10.1.0\Client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.96.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
!!!! Required element exist in the list of assistant !!!
Therefore you virsion exlude.
|
|
Wed Dec 06, 2006 3:01 am |
![ICQ Number ICQ Number](templates/GreenTech/images/lang_english/icon_icq.gif) |
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Here are images demonstrating the issue (emailed by mmx)
Before typing "vms"
after
![](http://www.softtreetech.com/support/vms_u2.jpg)
|
|
Wed Dec 06, 2006 8:44 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Did you modify "Objects" query in SQL Assistant options by any chance?
|
|
Wed Dec 06, 2006 1:10 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mmx
Joined: 05 Dec 2006 Posts: 8
|
|
|
|
No.
select
object_name, substr(object_type,1,2)
from
all_objects
where
owner = :OWNER
and object_type in (
'TABLE','VIEW',
'PROCEDURE','FUNCTION','PACKAGE',
'MATERIALIZED VIEW','MATERIALIZED VIEW LOG'
)
union all
select
synonym_name,
decode(owner,'PUBLIC','SP','SN')
from
all_synonyms
where
owner in (:OWNER,decode(user,:OWNER,'PUBLIC',''))
and instr(synonym_name,'/') = 0
order by 1
|
|
Thu Dec 07, 2006 2:23 am |
![ICQ Number ICQ Number](templates/GreenTech/images/lang_english/icon_icq.gif) |
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Hi. This should be fixed in the latest build 1.0.49. Please download and check if it works for you.
|
|
Thu Dec 07, 2006 12:40 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mmx
Joined: 05 Dec 2006 Posts: 8
|
|
|
|
EEE!!! All works!
Thanks!
|
|
Fri Dec 08, 2006 3:35 am |
![ICQ Number ICQ Number](templates/GreenTech/images/lang_english/icon_icq.gif) |
![](templates/GreenTech/images/spacer.gif) |
|