Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

OUTLN user exists during upgrade

SOLVED
Go to solution
Jeff Ohlhausen
Frequent Advisor

OUTLN user exists during upgrade

Hi,
I'm upgrading from version 8.1.6.2 to version 8.1.7.4.0. I'm going through the oracle checklist of steps and one steps is to make sure there are no users or roles called OUTLN or MIGRATE.
Well, OUTLN exists is my database but oracle doesn't say what to do if the user is already there.
So I have a two part question?
1) what does the user do?
2) should I remove the user?

Thanks
Jeff
Do or do not - there is no try.
4 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: OUTLN user exists during upgrade

If you have that user prior to the upgrade in dba_users you should delete that user.

If you've done a lot with that user you may have to change ownership of objects to another user.

My recollection is the OUTLN user is created and used to migrate data.

You have to remove it to run the migrate. You must first see what that user owns. It might be left over from a past migration, which means you can remove the users and objects with the cascade function.

You need to be sure though and back up that database before you start.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
A. Clay Stephenson
Acclaimed Contributor

Re: OUTLN user exists during upgrade

My Oracle 8.1.7 Migration Guide states (pg 7-4)

Note: If you are upgrading from an 8.1 release, then you do not need to perform this check because the OLTLN user should have already been created when you installed the previous 8.1 release. Therefore, if you are upgrading from an 8.1 release, then go to Step 7 now. DO NOT DROP the OUTLN user if you are upgrading from a previous 8.1 release.
If it ain't broke, I can fix that.
Volker Borowski
Honored Contributor

Re: OUTLN user exists during upgrade

Just informational,

what does this User do ?

This user owns the objects that are needed to provide the use of "stored outlines".

Here is an example:
www.jlcomp.demon.co.uk/04_outlines.rtf

I always wanted to try to attach the executionplan of

SELECT Salery from USER_DATA where type='MANAGER';

to the one from

SELECT 'No Money today!' as Salery from dual;

But I never made it so far. Do not know if it would be possible at all.

Have fun
Volker
Yogeeraj_1
Honored Contributor

Re: OUTLN user exists during upgrade

hi,

The OUTLN should not be dropped. This user owns the package OUTLN_PKG which is used to manage stored outlines and their outline categories. There are other tables (base tables), indexes, grants, and synonyms related to this package and problems can be encountered should this schema be dropped.

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)