DMP tables Import and export from Oracle database
Import:
Start-to-run input cmd enter
# #语法格式为: Imp username/password @ip address/database name file= ' dmp file path ' full=y
C:\users\administrator>imp Testuser/[email PROTECTED]/ORCL file='C:\Users\Administrator\Documents\szj\wzcl2.dmp'Full=y# #下面为运行后效果import:release 11.2.0.1.0-production on Wednesday May 18:43:39 2017Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved. Connect to: Personal Oracle Database 11g Release 11.2.0.1.0-64bit productionwith The partitioning, OLAP, Da Ta Mining and Real Application testing options The export file created by export:v11.02.00 through the regular path warns that these objects are exported by Shaozhaojun, not the current user has completed zhs16g The BK character set and the import in the Al16utf16 NCHAR character set. Importing Shaozhaojun objects into TESTUSER. Importing Shaozhaojun objects into TESTUSER. . Importing table "yj_201704" Imported 9349 rows: Importing table "yj_201703" Imported 2622 rows: Importing table "yj_201702" Imported 1107 rows: Importing table "YJ201701" imported 1741 rows successfully terminated the import without warning.
Export:
# #语法格式: Exp username/password @ database address/database name file= ' Save DMP file path and file name ' tables= (table name in database)
C : \users\administrator>exp testuser/[email protected]127.0 . 0.1 /orcl file= " d : \emp.dmp " tables= (EMP) # #下面是运行效果 export:release 11.2.0.1.0-production on Wednesday May 19:39:25 2017Copyright (c) 1982, for Oracle and/or its Affiliates. All rights reserved. Connect to: Personal Oracle Database 11g Release 11.2.0.1.0-64bit productionwith The partitioning, OLAP, Da Ta Mining and Real Application testing options exported ZHS16GBK character set and Al16utf16 NCHAR character set are about to export the specified table through the regular path ..... Exporting table EMP Exported 112 lines successfully terminated the export without warning.
End!!!
Import and export of oracle-dmp tables