102 reputation
1
bio website
location
age
visits member for 2 years, 7 months
seen Dec 4 '12 at 18:28

Jul
18
answered enq: TX - row lock contention creating session waits
Jul
12
answered Oracle 10g: query takes long time and adding index does not help
Jul
11
answered Oracle out-of-place upgrade on same host: impdp issues
Jun
8
answered Remote to a remote oracle server and get running instances?
Jun
4
answered What exactly is “pinning” in relation to indexes?
Jun
4
comment Execute a script with SQLPlus containing blanks, semi-colons, and forward slashes
This issue can easily happen when using command line execution of SQLPLUS. While you are inside the SQLPLUS program, the command line editor is also still active. As a result, items that are relevant to the command line editor (blank spaces are interpreted as command/variable, semi-colons are seen as end of command). That is why having a '@' in a password causes nothing but heartache when you try to sign in (everything to the right of @ is seen as the name of a DB). During a major deployment, we found issues with blank spaces that forced us to deploy stuff through TOAD. SQLPLUS was useless to
May
17
answered What methods are available to create a snapshot of an oracle database for testing purposes?
May
11
answered My database dramatically increased in size. Why?
May
8
awarded  Teacher
May
8
answered Cannot login to Oracle11g with System username