Difference between SYS and SYSTEM
Could somebody explain the difference between these accounts? Another admin told me they always use SYSTEM and I always use SYS. There are many more objects owned by SYS (such as the DD) and I never gave it much thought. I noticed in MetaLink they suggested in a few places never to use SYSTEM and to use SYS instead for certain tasks. I suspect they have their own function and the installer seems to indicate that those accounts are created at the same time.
Thanks for any insight.