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?
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 Content Component encountered an error
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.