I would like to search through all of my procedures packages and functions for a certain phrase. Since it is possible to retrieve the code for compiled procedures using toad I assume that the full text is stored in some data dictionary table. Does anyone know where that would be? Thanks a lot ...
Unfortunately the BOL is a little vague on this, but index_id = 0 on sys.indexes or sys.partitions appears to refer to the table itself where there is no clustered index on the table. True - or am I missing something? ...
I am looking for an existing database of English words with each word separated by syllables. My purpose is to further edit each word in any selected article based on the separation of syllables. Does anyone know an existing product or method that can help me achieve this process? Thanks! ...
I need to document a legacy database schema for a new employee and as there's no design document I'd like to generate one from the existing schema. As the tables are MyISAM the foregin key relationships won't produce a nice graph. I'm interested in producing a document showing the important tables, their columns, types and remarks. Are ...
Hi, I have a database diagram in Visio 2007 and i want to generate a data dictionary of this diagram. Is there an easy way to do this? Thanks ...
I'm not overly familiar with the SQL Server data dictionary, but I've assumed what I'm trying to do is possible. We have a number of replicated databases, under different names say: Client1 Client2 Client3 Rather than rely on a naming convention, I was hoping to identify these databases, based on whether they include a key table, call ...
I'm trying to query the data dictionary to find information on the transformations in the database. I've given my user DBA privileges, so I can access the DBA_ dictionary views. With this user, I can access all the DBA_ views without issues, however it seems I can only access DBA_TRANSFORMATIONS when logged in AS SYSDBA. Am I missing a s...
I have large and complex SQL Server 2005 DB used by multiple applications. I want to create a data-dictionary for maintaining not only my DB objects but also cross-reference them against applications that use a specific object. For example, if a stored procedure is used by 15 diffrent applications I want to record that additional data t...
I've got the following objects: CREATE FUNCTION CONSTFUNC RETURN INT DETERMINISTIC AS BEGIN RETURN 1; END; CREATE TABLE "FUNCTABLE" ( "ID" NUMBER(*,0) NOT NULL, "VIRT" NUMBER GENERATED ALWAYS AS ("CONSTFUNC"()) NULL ); however, the functable => constfunc dependency is not listed in all_ or user_ dependencies. Is there anywhere I ...
Hello everybody, I am in dire need of help on how to explain what a data dictionary record is... I've been on Google all night and couldn't find a thing. From a few investigations I was able to find some information, which is below, but i don't know how to link them up nor find the correlation between them. The Topic I'm focusing on is...
How can I find out what, if any, indexes are set up on the oracle data dictionary tables themselves (eg on the columns of all_tables or all_source)? ...
For a normal index constraint, you can find the columns it is on by querying the all_ind_columns sysview using the index name in all_constraints. But if the constraint is disabled, no index exists, and there doesn't seem to be anywhere else that has constraint column information. How can I get the columns of a disabled index constraint f...
Oracle 9i has nested tables, however it doesn't have the all_nested_table_cols sysview (like 10g and 11g) which lets me see what the columns are for these nested tables. How can I find this information on a 9i database? ...
I'm running the following query: SELECT * FROM all_tab_cols c LEFT JOIN all_varrays v ON c.owner = v.owner AND c.table_name = v.parent_table_name AND c.column_name = v.parent_table_column On a 10g server this takes ~2s, on 9i this takes 819s (13 mins)! What on earth is causing this huge performance difference, and how can I fi...
11g and 10g both have the all_queue_subscribers (and user_, dba_) dictionary tables for listing the subscribers to queues, but this doesn't exist on 9i. Does the same concept of queue subscribers exist on 9i databases, and where can I get this information from? ...
When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can ...
I've used an early binding of a dictionary<string, string> to a gridview to show Urls Text and its HRef as key-value and it works like a charm. But since I want to replace the dictionary with this one : dictionary<string, LinkInfo> the binding goes wrong! Should I handle some events like as onItemDataBound or something? and the LinkI...
When I create an Oracle database it has a lot of tables in it with strange names. What are these tables? Should I keep them? If not, how can I avoid creating them? These are the table names: LOGMNR_UID$ LOGMNR_SESSION_EVOLVE$ LOGMNR_GLOBAL$ LOGMNR_RESTART_CKPT_TXINFO$ LOGMNR_AGE_SPILL$ LOGMNR_SPILL$ LOGMNRC_DBNAME_UID_MAP LO...