Q

Exporting users into dump files

Does the Oracle export utility export all the users created together with the password into the dump files for later import into another server?

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 was last published in January 2007

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close