Imp import and exp Export

Import as needed (the log file must be added): C: UsersAdministratorexpscottscott @ orcl11gfiled: temp1.dmplogd: templog. note for log export: The data of the current user is exported. If the current user has DBA permission, all data is exported! Therefore, fully needs to determine the application environment C: UsersAdministr

Import as needed (log files must be added): C: \ Users \ Administratorexp scott/scott @ orcl11g file = 'd:/temp/1. dmp 'Log = 'd:/temp/log. note for log 'export: The data of the current user is exported. If the current user has DBA permission, all data is exported! So full = y needs to determine the application environment C: \ Users \ Administr

Import as needed (log files must be added ):
C: \ Users \ Administrator> exp scott/scott @ orcl11g file = 'd:/temp/1. dmp 'Log = 'd:/temp/log. Log'

Note: The data of the current user is exported. If the current user has DBA permissions, all data is exported! So full = y needs to determine the application environment
C: \ Users \ Administrator> exp scott/scott @ orcl11g file = 'd:/temp/1. dmp 'Log = 'd:/temp/log. log' full = y

Export a specific table
C: \ Users \ Administrator> exp scott/scott @ orcl11g file = 'd:/temp/1. dmp 'Log = 'd:/temp/log. log 'tables = scott. dept

Export the tables of system users and sys users in the database
Exp scott/scott @ orcl11g file = d: \ daochu. dmp owner = (system, sys)

Export the data headers starting with "79" for the field empno In the table emp in the database
Exp scott/scott @ orcl11g file = d: \ scott. dmp tables = (emp) query = \ "where empno like '000000 '\"

Data Import between different names: (import and export according to the scheme)
C: \ Users \ Administrator> imp scott2/scott2 @ orcl11g file = 'd:/temp/1. dmp 'Log = 'd:/temp. /1. log 'fromuser = scott touser = scott2
Import data with the same name

C: \ Users \ Administrator> imp scott2/scott2 @ orcl11g file = 'd:/temp/1. dmp 'Log = 'd:/temp./1. Log'

Imp hkb/hkb @ xe file = c: \ orabackup \ hkbfull. dmp log = c: \ orabackup \ hkbimp. log full = y