Imp import and exp export, Imp Import and Export exp
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
Import imp from Oracle to export exp
Yes. I tested it.
Data export:
1. Export the database TEST completely, and the username system Password manager is exported to D: \ daochu. dmp.
Exp system/manager @ TEST file = d: \ daochu. dmp full = y
2. Export the tables of system users and sys users in the database
Exp system/manager @ TEST file = d: \ daochu. dmp owner = (system, sys)
3. Export the inner_policy and policy_staff_relat tables in the database.
Exp aichannel/aichannel @ TESTDB2 file = d: \ data \ newsmgnt. dmp tables = (inner_policy, policy_staff_relat)
4. Export the data with the field filed1 in table 1 in the database starting with "00"
Exp system/manager @ TEST file = d: \ daochu. dmp tables = (table1) query = \ "where filed1 like '201312 '\"
-- Test Statement (replace the Input key with the input key)
Exp Usename/passwd @ sid file = d: \ t
Est. dmp query = \ "where columnname between DATE '2017-04-05 'and date '2017-04-10
'\ "Tables = (tablename)
In linux, how does one use exp and imp to export and import the specified oracle database table?
Exp help = y
Imp help = y
Clearly stated
You can archive databases without archiving them. scott is a user name and tiger is the user password. For example
Exp scott/tiger owner = scott file = temp. dmp log = temp. log
Exp scott/tiger tables = (emp, dept) file = temp. dmp log = temp. log