Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Full database imort issue !!

Chris Fung
Frequent Advisor

Full database imort issue !!

Hi there,

Just wondering if I run a full database import against a database, will the user account password be overwritten in the target database ?

I am currently using Oracle 8.1.7.

Test shows me that the existing user account and password in the target database remains the same. I think this issue may affect if the import job is for a disaster recovery situation.

Any comments ??


Brian Crabtree
Honored Contributor

Re: Full database imort issue !!


I'm not sure what you are looking for. The IMP_FULL_DATABASE role has the BECOME USER privilege, which lets it create objects as another user. There isn't any real knowlege of the password in the import dump file, just the encoded value of the password that can be loaded into Oracle directly.

Provided that the user exists on the database (or can be created with the import), then the objects should be created, provided that tablespaces exist with sufficient space.


Indira Aramandla
Honored Contributor

Re: Full database imort issue !!

Hi Chris,

Performing a FULL Export will export the entire database. Performing a FULL import will import everything in the export dump file.

A full import will create any undefined tablespaces using the same datafile names as the exported database.

If you have a target database, and the users, datafiles, tablespaces are pre-created, import will not change the user passwords in the target database.

Indira A

Never give up, Keep Trying
Emilio Brusa
Frequent Advisor

Re: Full database imort issue !!

Indira,in imp full=y if your you have one user created in base target with the same username of the user of the base origin the password of the base target be overwritten, because you are importing the data dictyonary too.
IF the user didn't exist in the base origin there won't be changes.

If the users of the base origin for the disaster recovery didn't exist in the destination, I don't see problem, if for the opposite they already existed you have to fight with the integrity of your data.