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

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
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
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
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/…
Dec
16
comment database design for storing individual users' items
how many users, what data type and how large are the columns A,B,C,D?
Dec
16
comment Standard data types for email address, telephone number , first name, rixh text editor, etc
Whatever is suggested, make it larger....
Dec
3
comment Prevent row from being inserted with a trigger
oracle version please and actual output should be logged to a table so we can see what happens on an insert. Or do you have the output from an insert?
Nov
26
comment Toad 9.7.2 for Oracle hangs on Windows 7
what version of oracle are you connecting to?
Oct
17
comment grant permissions in oracle from one database to another
Are they actually two different instances on the same machine? Or two schemas on the same machine, or two instances on different machines?
Sep
22
comment How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?
Ah, Forms... You can do stored procedures in Forms and skip the triggers if you like.
Sep
19
comment How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?
You are really handcuffing yourself with all the things that cannot be changed. Have you considered Advanced queues, or a table that is inserted into every time a row is changed?
Sep
18
comment Oracle remote OS authentication, security risks with domain users
what testing have you tried?
Sep
5
comment Is it possible to get this output in Oracle 8i?
What have you tried?
Sep
2
comment How to put more than 1000 values into an Oracle
Can you create an external table in a directory?