Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PaulinaK

    Compare db and data model

    Hi all, We have an Oracle 8.1. db and a Server Model in Oracle Designer 6i. The model is pretty outdated and I need to bring it back in sync with actual db (db objects as well as administration objects such as users, roles, etc). I would not want to simply reverse-engineer the db into Oracle...
  2. PaulinaK

    PowerCenter Manuals anyone?

    Hi All, I am new to Informatica and was wondering if anyone has any manuals/tutorial materials on PowerCenter 5, 6 or 7. We don't have the product installed yet, so I can't use online help. But need to get a good idea about how it all works. If anybody could help me out and send me...
  3. PaulinaK

    SOUNDEX for non-English names?

    Can anybody please tell me how standard Oracle 9i SOUNDEX will work with non-English names (say, Spanish)? Also, how does standard Oracle 9i SOUNDEX handle names with hyphens? Note: Please don't tell me about new/improved/custom-coded matching algorithms. I know one can code anything, if...
  4. PaulinaK

    Audit: perf and space impact?

    Thanks Mufasa. This is what I suspected based on common sense. Quick follow up question regarding the UPDATE transactions and their audit(while on this topic): does Oracle Audit feature let me clearly store/see old and new values, or do I have to dig through the DML statement to see the new...
  5. PaulinaK

    Audit: perf and space impact?

    Question: is it a good/bad idea to turn statement auditing on for all INSERTs, UPDATES, DELETEs on all tables? Purpose: we need to be able to go back and see who changed what data in the db. How much of an impact would it have on performance (overhead)? How much of a space issue would it be...

Part and Inventory Search

Back
Top