OUTLN user exists during upgrade

[Jeff Ohlhausen]

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

[Steven E. Protter · Accepted solution]

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

[A. Clay Stephenson]

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.

[Volker Borowski]

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]

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