Re: SYS and System

From: Andrew Babb <andrewb_at_mail.com>
Date: Thu, 08 Apr 1999 11:42:40 +0800
Message-ID: <370C25B0.AEE82D21@mail.com>

Frank,

Objects under the SYS account are purely data dictionary objects, and are not exported by a full database. i.e. tab$, obj$, fet$.. anything associated with the internals of this particular database.

Objects under the SYSTEM account include Oracle Forms, Menu and Report objects generally. These objects, you want to have backed up when a full database is being exported.

Also, when you move from one Oracle Instance to another, the actual places where tables are created (SYS account) will be different, but you still want your application menus to be the same (SYSTEM account). In short, if you want it moved by Export / Import put it in SYSTEM, if you cannot find an alternative APPLICATION SYSTEM account like SCOTT. (Bad Example but hopefully you get the idea).

Hope this helps,
Andrew

Frank Siegel wrote:

> What's the difference between the user/schemas SYS and SYSTEM?
>
> Thanks in advance
> Frank S.
Received on Wed Apr 07 1999 - 22:42:40 CDT