Red Gate forums :: View topic - edition- based redefinition
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Source Control for Oracle
Source Control for Oracle forum

edition- based redefinition

Search in Source Control for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 28 Mar 2014
Posts: 1
Location: San Francisco Bay Area

PostPosted: Fri Mar 28, 2014 3:48 pm    Post subject: edition- based redefinition Reply with quote


When we create the very first edition as a child of ORA$BASE, and grant some package to it or re-compile some package, this package gets assigned to our new edition as expected:

create edition v36 as child of ora$base;
alter session set edition=v36;
grant execute on P_CONF_MERCH_ETL to IHUB_ETL;

Now, what is the pro and con of running a LOGON trigger to enable v36 for all new logon to Oracle, vs. doing ALTER SYSTEM SET DEFAULT EDITION = v36 ?

and how can we 'purge' older editions, if every new edition we create always 'is a child of ' the older edition? Oracle will not let us drop those older editions, and is this a problem at all, if say we create 20 new editions per year, for 5 years?

How do we manage completely non-editionable objects such as TYPES and AQ queues, and sequences? anything special to consider as we implement EBR for all of our OWNER schema for these non-editionable types? I know function based index will raise an error because INDEX is non-editionable, and function is, so if you can re-write the function as a inline CREATE INDEX expression, it will solve the issue. but what if you cannot?

sorry, that is more than 1 question.. Purging EBR is the main question.
thanks in advance!
Back to top
View user's profile Send private message Send e-mail
eddie davis

Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Mon Mar 31, 2014 2:44 pm    Post subject: Reply with quote

Hi, thank you for your forum post.

With regards to your questions, what relevance are they to our Oracle Tools and our Source Control for Oracle product?

I have no idea regarding the pro and con of running a LOGON trigger. Likewise purging older editions and something called EBR.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group