Reputation
16,750
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
8 41 116
Newest
 Nice Answer
Impact
~1.7m people reached

Jan
21
answered Duplicate databases error
Jan
14
awarded  Popular Question
Jan
6
comment Does the target for Double-Take replication require an Oracle license?
@MaxVernon Understandable.
Jan
5
reviewed Leave Open How can I lock an INSERT operation
Jan
5
reviewed Leave Open Time series and gap filling
Jan
5
comment Does the target for Double-Take replication require an Oracle license?
I did contact Oracle, see my answer below.
Jan
4
awarded  Yearling
Dec
10
accepted What is meant by the RMAN Duplicate “noncurrent point in time”?
Nov
19
awarded  Enlightened
Nov
19
awarded  Nice Answer
Nov
10
awarded  Famous Question
Nov
6
awarded  Nice Answer
Nov
5
comment glogin.sql supress error when Instance Idle
I'm still not sure how to make it work for a PL/SQL block, so if anyone can add an answer for that I'd +1 it.
Nov
5
comment glogin.sql supress error when Instance Idle
I saw that too, but wanted to display the output rather than changing the prompt. I was able to use it though by selecting the data for the two lines I want to display inside a set term off, set term on block like Kyte does. By pre-setting the values to " " before the block the the error isn't displayed if the database is down only a few extra blank lines. Thanks for your input.
Nov
5
comment glogin.sql supress error when Instance Idle
Are you proposing that this shell script be run from glogin.sql? If so, how will the script communicate to glogin that the pl/sql block should be run or skipped?
Nov
5
accepted glogin.sql supress error when Instance Idle
Nov
4
asked glogin.sql supress error when Instance Idle
Nov
3
answered Which version is the right one to begin with Oracle
Nov
3
answered Oracle static lookup table
Nov
3
comment What exactly is a database engine?
@Pacerier - This may be true for systems that make a separation between the DBMS and storage engine, for others the distinction is meaningless.