Oracle Data Import and Export dmp

Oracle Data Import and Export dmp

1: Start-> Run-> cmd-> exp-> User Name/password @ connection word (DBA permission is required for full Database Export)-> press ENTER-> enter the export path (C: /AA. DMP)-> select (E, U or T) as required-> press ENTER or enter yes or no as required.
IMP is also a similar execution method.

 

Or remember the following command to execute import and export.

 

2: import:
For example, import the data file expdat. dmp as the aaauser.
IMP aaauser/password file = expdat. dmp
Note: aaauser/password: User Name/password; file = file_name (data file name) and then follow the prompts to perform the operation.
Note: When importing data, if the user already has data objects, delete the user first, create a user, authorize the user, and import the user.
Export:
For example, export data of the aaauser user to the file expdatback. dmp.
Exp aaauser/password file = expdatback. dmp
Note: aaauser/password: User Name/password; file = file_name (data file name) and then follow the prompts to perform the operation.
When importing data, if the user is different, an error will be reported. You only need to follow the prompts to change the user. After the import is successful, another warning will be reported, so ignore it!