16,225 reputation
837109
bio website isworthy.wordpress.com
location Plantation, FL
age 37
visits member for 4 years
seen 2 days ago

2d
awarded  Enlightened
2d
awarded  Nice Answer
Jan
22
comment what is the difference between data file and data block in oracle
@a_horse_with_no_name Both my link and yours point to the 12c Concepts Guide. The difference is that mine is to the pdf and yours is to the web documentation - each useful depending on how it needs to be consumed.
Jan
22
answered what is the difference between data file and data block in oracle
Jan
22
awarded  Famous Question
Jan
21
answered Database design for attendance feature
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.