Forum Stats

  • 3,853,719 Users
  • 2,264,259 Discussions
  • 7,905,435 Comments

Discussions

Flashback schema

doc_scsi
doc_scsi Member Posts: 3 Red Ribbon

Hi

Please implement the ability to flashback an entire schema.

Today, one can create a script to use flashback table to flashback all tables of one or many schemas at once. This is limited to table objects only, but there are many other objects types in a table as well.

This feature would greatly support the well known and very robust technique of schema consolidation, where you consolidate many applications having one or many different schemas in one single database. Application schemas should be self-contained and not overlapping, so one schema should exactly belong to one application (or none, then it's oracle internal).

This is probably hard to get it. At table level, can be done from undo but that's valid only for small tables. At tablespace level, could be done with flashback logs and redo. In both cases, there is the need to sync all metadata at the same timestamp.

Thanks for considering this idea

Casi

doc_scsiFranck Pachot
2 votes

Active · Last Updated