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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close