answersLogoWhite

0

What are scn numbers?

Updated: 8/16/2019
User Avatar

Wiki User

6y ago

Best Answer

The scn is an ever-increasing number. It can be used to determine the "age" of the database and its component datafiles.

The current system SCN can be queried using dbms_flashback.get_system_change_number.

The SCN of the last checkpoint can be found in v$database.checkpoint_change#.

The SCN is needed in a flashback table .. to scn ... statement.

Within this context, SCN stands for System Change Number.

User Avatar

Wiki User

6y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are scn numbers?
Write your answer...
Submit
Still have questions?
magnify glass
imp