oracle--Import/Export data: Exp,imp command

The exp,imp command is a command that needs to be executed in the cmd command of Windows, primarily for import and export of data, and is convenient and efficient.

Remote Address--@ip: PORT/ORCL Note: This remote address does not write, which means that the local library is executed.

Oracle's Data export

(1) Prompt mode for exporting data:

Exp Jl_bhps/[email PROTECTED]:1521/ORCL

(2) Table mode: Exports the data for the specified table.

Exp jl_bhps/[email PROTECTED]:1521/ORCL file=d:temp/1.dmp log=d:temp/1.log tables=emp,dept

(3) User mode: Export all objects and data of the specified user.

Exp Jl_bhps/[email PROTECTED]:1521/ORCL file=d:temp/1.dmp log=d:temp/1.log

(4) Full-Library mode: Export/Import all objects in the data (log in with Administrator account)

Exp system/[email PROTECTED]:1521/ORCL file=d:temp/1.dmp log=d:temp/1.log full=y

Data Import for Oracle

(1) Prompt mode for importing data:

Imp Jl_bhps/[email PROTECTED]:1521/ORCL

(2) Import a table or several tables.

Imp jl_bhps/[email protected]:1521/orcl file=d:temp/1.dmp log=d:temp/1.log tables=emp,dept Fromuser=scott touser=jl_b HPS Commit=y Ignore=y

(3) Import the table under User

Imp jl_bhps/[email protected]:1521/orcl file=d:temp/1.dmp log=d:temp/1.log Fromuser=scott Touser=jl_bhps commit=y Ignore=y

(4) Import Database

Imp system/[email protected]:1521/orcl file=d:temp/1.dmp log=d:temp/1.log full=y ignore=y destroy=y;

This article from "Yu elder brother Mighty" blog, please be sure to keep this source http://even2012.blog.51cto.com/5283686/1558203

oracle--Import/Export data: Exp,imp command