Re: Can't import SYS' procedures

Sorry, but you can't export anything owned by SYS. The reason for this is that SYS only owns the dictionary, which is maintained thru DDL (e.g. create commands found in an export file).

You should let another user be the owner of these procedures, and SYS should give the necessary privileges on the relevant views to this user.

Mark Wagoner wrote:
>
> I have two stored procedures that were created under SYS because they need
> access to some of SYS' views. I had to do an export/import to de-frag my
> tablespace and now these procedures won't import.
>
> I created the export file as SYS and did a full database export. I
> imported the database as SYS and I get everything but these two procedures.
> I have also explicitly tol import to import user SYS, but no luck. Import
> reports that it completed successfully without warnings but the procedures
> are not there.
>
> Anyone know what I am doing wrong?
>
> --
> Mark Wagoner
> mwagoner_at_no.spam.medplus.com
>
> To reply, remove no.spam from my mail address.
 

-- 

Odd Harry Ophaug
IFS Norway