SCN/ora_rowscn Questions

  • From: Woody McKay <woody.mckay@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 Aug 2015 11:35:00 -0400

Hi all,

I was reading an AskTom article and it talked about the SCN wrapping at
some point. If this is so, then how large can the SCN grow to before it
wraps? Where is the wrap count stored?

On imports, ora_rowscn on table data will get scn's from the DB scn and not
what was exported?

The only use of the scn in a datapump file would be used for flashback_scn?
Right?


Thanks for all answers.

--
Sincerely,

WoodyMcKay

Other related posts: