Thursday, July 19, 2012

Find all dependent objects in oracle

Yesterday I had a scenario where I need to find the objects that are dependent on a particular table in Oracle 10g. My friend Peter happily offered me the following code.
select *
from dba_dependencies dep
where dep.referenced_owner = 'TABLE_OWNER_NAME'
and dep.referenced_name = 'TABLE_NAME'
order by owner, name;

Monday, July 16, 2012

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database

You will need to reset your encryption keys. To do that: 1.Open Reporting Services Configuration Manager and select 'Encryption keys' tab 2.Click 'Delete' in 'Delete Encrypted Keys' section: 3.You will need to reset all connection strings and db credentials for all your data sources

How to use crow feet notation in data modeling in Enterprise Architect

1.Right-click data-diagram and select properties (you can do it in the working area directly or through browsing the Project Browser).
2.Navigate to the Connectors tab.
3.On the right side you'll see a small section labeled "Connector Notation", there you select "Information Engineering"

Citing Sources: [http://stackoverflow.com/questions/6690495/using-crows-feet-notation-in-data-modelling-in-enterprise-architect]: