I leave it to operations managers and development staff to tell me when to move schema objects to our "Obsolete" database. We have too much data that only gets hits for quarterly and annual summaries, then year to year comparisons to use any time based automatic archival process. *Richard W Weiss* Oracle DBA Student Assistance Foundation 2500 Broadway Helena, MT 59601 (406) 495-7356 Office (406) 438-7007 Cell rweiss@xxxxxxxxx *The best way to predict your future is to create it.* -- *A<http://www.brainyquote.com/quotes/authors/c/c_s_lewis.html> nonymous* On Thu, Apr 11, 2013 at 9:21 AM, rjamya <rjamya@xxxxxxxxx> wrote: > We upgade existing schemas, and it works well for us. > Raj > > > -- > //www.freelists.org/webpage/oracle-l > > > -- ---------------------------------------------- This email and any files transmitted with may be confidential and are intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the sender immediately and delete this e-mail from your system. This message may contain confidential information and the contents of this email are strictly prohibited from being disseminated, distributed, printed or copied. Student Assistance Foundation 2500 Broadway Helena MT 59601 http://www.safmt.org ---------------------------------------------- -- //www.freelists.org/webpage/oracle-l