PL/SQL compilation where the decision to make the dependent objects such as triggers, functions, etc invalid due to table alters are controlled by DBA. I understand this is being addressed in Data Vault.ĥ. A third account type will have access to audit trails only. A separate role will allow the data to be seen and allow privileges. Separation of roles where DBA can see the data files, dictionary, etc., but not the actual data. And, sweet oh sweet, I could edit the INP files for quick modifications. I miss the SQL*Forms 3.0 (if anyone is old enough to remember that)which allowed me to do quick and dirty data entry screens for dat manipulations. An unloader utility that reads at the block level and dumps data as plaintext ASCII much faster than the SQ*Plus or Pro*C programs can do.ģ. It doesn't have the powerful SQL*Plus commands.Ģ. No, Grid Control SQL Output just doesn't cut it it's a static output of the entire table. SQL*Plus with a built-in tabular format output useful for rows that span across many lines. I'll publish this to see what others add - maybe some have been addressed and we can point it out - others, I'll file away for the days when I'm asked "what would you add." I would appreciate better error messages sometimes - I can usually figure them out, but. There is so much in there - what I would change is peoples knowledge level of what is actually available. The (sometimes) developer approach of "I don't need to learn the database" Most of the things I would change are "political", the DBA/Developer relationship (or lack thereof). Maybe that is good.Īctually, many of those things I would change are being addressed - a better sqlplus that is still sqlplus (coming, code name "raptor", previewed at OOW). Scott schema does (ditto, dba just needs to have installed the demos)Īutotrace - yes, be nice if it were there HOWEVER, on a production system - it shouldn't necessarily be there so. Well, Oracle text does (dba just needed to have selected it).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |