We help IT Professionals succeed at work.

Syntax Error In Docs ???

xoxomos
xoxomos asked
on
i'm looking at the docs
http://docs.oracle.com/cd/A87862_01/NT817CLI/server.817/a76995/standbyr.htm#24223
When I copy and paste I get a syntax error on line 10.
What is the problem.

SELECT high.thread#, "LowGap#", "HighGap#"
FROM
     (
     SELECT thread#, MIN(sequence#)-1 "HighGap#"
     FROM
     (
         SELECT a.thread#, a.sequence#
         FROM
         (
             SELECT *
             FROM v$archived_log
         ) a,
         (
             SELECT thread#, MAX(next_change#)gap1
             FROM v$log_history
             GROUP BY thread#
         ) b
         WHERE a.thread# = b.thread#
         AND a.next_change# > gap1
     )
     GROUP BY thread#
 ) high,
 
 (
     SELECT thread#, MIN(sequence#) "LowGap#"
     FROM
     (
         SELECT thread#, sequence#
         FROM v$log_history, v$datafile
         WHERE checkpoint_change# <= next_change#
         AND checkpoint_change# >= first_change#
     )
     GROUP BY thread#
 ) low
 WHERE low.thread# = high.thread#;
Comment
Watch Question

Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Looks like there is a blank line in the sql.

Sqlplus doesn't like blank lines unless you tell it they are OK.

Author

Commented:
AH!!!! Forgot all about that.  Thanks again.