Is okay to export the SYS or SYSTEM or CTXSYS users and import them?

Posted on 2009-04-24
Last Modified: 2013-12-19
On an 8i or Oracle database
Is it okay to export the users:
and import them into another database or will this screw up the database e.g
the dbid and sids being wrong etc...
Question by:Robert Silver
    LVL 73

    Assisted Solution

    you shouldn't be able to export sys, system or ctxsys and import them.

    but if you could, I wouldn't try.

    if you want everything, just do a full db export which won't really grab those schemas even though it's called "full"
    and then do a full import into another db,  the dictionary schemas will be populated as you import the other schemas
    LVL 2

    Author Comment

    by:Robert Silver
    I do not wish to export the whole database as one export for several reasons
    1. The database is way too big
    2. I want more control over the import than that

    Can you suggest a way to determine individual schemas and will that be enough
    What about the JAVA users? Can I just import them??
    LVL 73

    Expert Comment

    you can import the java users as those aren't part of the oracle dictionary. those are application schemas
    LVL 47

    Accepted Solution

    You have to export only the nonsystem users.
    If you do full export Oracle will not allow you to update the
    SYS schema. There will be a lot of error messages in regard of these
    objects that normally are simply ignored.

    Concentrate on the user that constitutes (build) your application(s).

    About Java "users" - they are not users at all, they are roles that are created when you install the Java option on 8i:

    In 8.1.5, the security provided you the choice of two secure roles:

    JAVAUSERPRIV--few Permissions, including examining properties

    JAVASYSPRIV--major Permissions, including updating JVM protected packages

    So installing Java on 8i you will get also these roles and all other  objects in the Java stuff.

    Good luck!
    LVL 7

    Assisted Solution

    My recommendations in this regard are:
    Take a full export Dump from source database.
    Create a new empty database where you want to import. Create tablespaces and users.
    import the dump file user by user using fromuser=<source user>, touser=<target user>.
    No need to import SYS, SYSTEM etc. Because when you create a new database sys and system will be there.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now