Does the Oracle export utility export all the users created together with the password into the dump files for subsequent import into another server for secondary access purposes?

    Requires Free Membership to View

    Login

Only if you perform a FULL=Y export. With a full export, the dump file will contain the CREATE USER statements to create the new user. These users will have the same password in the new database. If you perform schema-level exports (OWNER=) or table-level exports (TABLE=), then you will not get the CREATE USER statements in the dump file.

This was first published in January 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top