topic Re: OUTLN user exists during upgrade in Operating System - HP-UX

OUTLN user exists during upgrade

Jeff Ohlhausen — Tue, 03 Feb 2004 15:26:44 GMT

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

Re: OUTLN user exists during upgrade

Steven E. Protter — Tue, 03 Feb 2004 15:44:47 GMT

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

Re: OUTLN user exists during upgrade

A. Clay Stephenson — Tue, 03 Feb 2004 15:57:57 GMT

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.

Re: OUTLN user exists during upgrade

Volker Borowski — Tue, 03 Feb 2004 16:52:49 GMT

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

Re: OUTLN user exists during upgrade

Yogeeraj_1 — Wed, 04 Feb 2004 00:34:44 GMT

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