Database Utilities (MOSC)

MOSC Banner

Edition-Based Redefinition

edited Jan 31, 2012 7:02PM in Database Utilities (MOSC) 2 commentsAnswered
Hello,
we have a porblem with Edition-Based Redefinition, and I hope, somebody can give me some good ideas to solve it.

We have a complex database with many public synonyms, what we use in Forms. We would like to use the editions, because we're developing a new program, and we want to use the new version and the old one together, but the new version has to use more datas from the same table and we thought the editions would be the good choise to do that.
Oracle's documentation says public synonyms are not editionable objects, and when we have tried to use edition and have made two edition with editionable view from a table, the database has crashed, and we couldn't fix that until restore it without editions.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center