I'm familiar with the issue behind ORA-01775: looping chain of synonyms, but is there any trick to debugging it, or do I just have to "create or replace" my way out of it? Is there a way to query the schema or whatever to find out what the current definition of a public synonym is? Even more awesome would be a graphical tool, but a...
Hi, Got into a situation where in a schema i have a table, say table ACTION , while i got a synonym called ACTION as well which refers to another table to another schema. Now, when i run the query select * from ACTION it will select the records from the table, but not the synonym. Anyway for me to select from the synonym AND the tab...
I've created a package that contains a stored procedure that I plan to invoke from a separate application. The stored procedure will return a sorted list of all the views and tables in the schema. To do that, it performs a simple select on the DBA_TABLES and DBA_VIEWS synonyms, as shown below: CREATE OR REPLACE PACKAGE BODY TITAN_ENTITY...
Hi everyone, can someone tell me why the following behavior occurs (Oracle 10.2): SQL> create table part_test ( i int primary key, d date ) partition by range (d) (partition part_test_1 values less than (to_date(' 2 3 4 5 1980-01-01', 'yyyy-mm-dd'))); create public synonym part_test for part_test; select obj...
I'm using ms sql 2008 and trying to create a database name that references another database. For example 'Dev', 'Test', 'Demo' would be database names that i could reference from my multiple config files, but each name would point to another database such as 'db20080101' or 'db20080114'. [Edit]Some of the configs are for applications t...
I have a very unusual situation that I am hoping someone will be able to shed some light onto. My understanding of an oracle synonym is that it is basically an alias to a table in another schema. When I do a count from the synonym, it returns zero rows. When I do the same from the underlying table, it returns 12 thousand rows. I cannot...
I've been doing a lot of DB refactoring lately and synonyms have come in incredibly useful. When I originally put in the synonyms I was thinking they would be very temporary while I refactor. Now I am thinking there might be some good reasons to keep some of these synonyms around. Has anyone used them as full blow abstraction layer? Wh...
Hi all, We have a client who is looking for a means to import and categorize a large amount of textual data. This data has to be categorized and it's been suggested that the easiest way to to do this would be to look at the description field and try to match the words held there to see if a category can be derived for that particular r...
Out of curiousity, is there any way to edit an existing synonym? That is, change which table the synonym is pointing to... Thus far I seem to have had to delete and re-create them, because they're locked from being edited. It's not a big deal, but at the same time it's a little irritating. GUI or scripting, but preferably GUI. ...
I plan on updating some table names by create a synonym of the old name and renaming the table to what I want it to be. Can replication properly reference a synonym? Also as a side question, is there an easy way to see if a specific table is actually being replicated? (via a query perhaps) ...
I have created public synonym as suggested in my other question about creating view at system level. Having said that I have created individual public synonym out of the view so that I don't have to connect to the individual domain anymore. My problem now is how to create a master kind of public synonym to capture all those synonyms whic...
I see from BOL that you can apply permissions to a T-SQL synonym, but in playing around with synonyms I'm not clear when you would need to do that if you have already GRANTed permissions to the base object. eg. If I have a synonym in database A that points to a table FRED in database B, then it appears that as long as user Joe is grante...
I have multiple databases on a single instance of SQL Server 2005. I've created a synonym on one database to access a table on another database and when writing my queries, I'd like to utilize a specific index, however, when evaluating the execution plan, it doesn't appear to use it. If I write the query to access the database explicit...
Hello, I've been trying without success to add a reference to a public synonym in a package or stored procedure in oracle for a while, and I'm wondering if there are solutions to this problem short of accessing the tables directly. For instance: CREATE OR REPLACE PROCEDURE test_func AS test_int INTEGER;<br> BEGIN<br> select coun...
So here the scneario. We have a database of read only records that contains about 3 million rows. This database is used by all of our application databases for data lookup. We placed this database on a new server and used a synonym to point to it in the local database. The synonym was pointing to a view on the remote server. This allow...
I know dbsight allows synonyms and stop words for searching but does this take care of inflectional forms of a verb too e.g. for 'swim' it should find swim, swims, swimming, swam, and swum Link on DBSight Wiki : http://wiki.dbsight.com/index.php?title=User%5Fdictionary ...
Hi, I just had an idea last nigth when writing an if-expression and sometimes the expression tend to be long when you have it like this: if(x == 1 || x == 2 || x == 33 || x == 4 || x == -5 || x == 61) { ... } x can be enums,strings,ints,chars you get the picture. I want to know if there are an easier way of writing this. I think of ...
How can I create a public synonym in oracle 7.3.4 for a common table located in different users. ...
I have Solr with indexed database. In my database all data is in Latvian. The problem is, I need to be able to search word Riga as if it is word Rīga. Of course, i can define synonym - Rīga = Riga, but can i just define, that letter ī is letter i? I read something about solr.ISOLatin1AccentFilterFactory, but as far as i understood, this...
Hi, I've been searching the web for two days and still cannot find a way to generate DDL code with public synonyms. Would be very grateful for an advice. ...