This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Last Captured SCN

How can I find out the last captured SCN for a capture process. 'show capture detail' shows me the redo log and log offset, but I don't see where the Oracle SCN is reported.

+1 Clay.Jackson over 8 years ago

Hi - you should be able to use the "show SCN" command.
Cancel
Up 0 Down

Cancel
0 jmason over 8 years ago

Thanks for the reply Clay. I also spoke with Support, who explained that the SCN displayed on the 'post' side is actually the SCN from the source database, so I can derive the captured SCN in that way also.
Cancel
Up 0 Down

Cancel