Reputation
2,092
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
9 33
Impact
~161k people reached

Mar
4
revised Removing editioning from an Oracle user
added 390 characters in body
Mar
4
asked Removing editioning from an Oracle user
Mar
3
comment Clarification on usage of Serially Reusable Pragma for Oracle 10g
I was never able to get this to work using the Pragma or editioning. If you have a package that you cannot use here and here or here what good is it? I follow best practice and do all changes to production during a time period agreed on by the application owners
Feb
27
comment Best place to keep backup scripts
and in your documentation too with notes on how it works
Feb
27
comment Is EAV an appropriate design for a collection of coexisting metadata-rich “fact estimates” on objects?
double weird, link works in IE (!!!) but not direct from chrome
Feb
27
comment Is EAV an appropriate design for a collection of coexisting metadata-rich “fact estimates” on objects?
link is down for me
Feb
27
comment Why do I get this CMN_1021[ORA-03135: Connection lost to contact
Intermittent network issues?
Feb
26
comment Why am I able to query a remote database without a dblink?
Please show us what script the users use to do this
Feb
26
answered BLObs – Should I Store In Database Or in Directory Structure?
Jan
29
comment IMPDP twice with same Oracle EXPDP dumpfile with different results?
are you using the consistent parameter in the export? "The exp utility used the CONSISTENT=Y parameter to indicate the export should be consistent to a point in time"
Jan
28
comment How to normalize a table that contains a CK not included in the PK?
I question your assumption that modelName is unique. They can change and are outside your control. Why not just stick with a primary key?
Jan
28
comment optimizing init.ora oracle database server
It's unclear what you are asking. What is the problem?
Jan
23
answered Error in trigger: table X is mutating, trigger/function may not see it
Jan
21
comment Trying to Figure out an ER Diagram for a set of instructions
you need to show what are the one to one and one to many relationships
Jan
21
revised Auditing Specifications for SQL Server 2012
corrected formatting, removed redundant words
Jan
21
suggested approved edit on Auditing Specifications for SQL Server 2012
Jan
16
comment Restoring an Oracle Backup Properly
I hope for your sake that this is development.
Jan
15
comment Large sequence cache in Oracle
don't suppose you can use SYS_GUID() for your primary key? No caching required then...
Jan
14
comment What storage engines work with Oracle?
learn something new every day with Oracle..
Jan
9
comment where is oracle session timezone set?
@JoshuaHuber Thanks, that is correct for Java and Oracle databases, no more three letter abbreviations, use 'America/New_York' docs.oracle.com/cd/E11882_01/server.112/e10729/…