| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle Streams SCN instantiation
Hello,
is way to get lowest SCN from table?
Oracle doc proposes using
DBMS_CAPTURE_ADM.PREPARE_TABLE_INSTANTIATION(table_name)
or
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER().
Last one seems is not correct
because procedure returns current SCN.
The first procedure really records the lowest SCN of the table
for instantiation but where?
-- SLReceived on Sat Dec 20 2003 - 06:59:33 CST
 |
 |