Shulou(Shulou.com)06/01 Report--

Exp,imp command is a command that needs to be executed in the cmd command of windows. It is mainly used for data import and export, which is convenient and efficient.

Remote address-@ ip:port/orcl Note: if the remote address is not written, it means that the local library is executed.

Data export of Oracle

(1) prompt mode for exporting data:

Exp jl_bhps/abc123@192.168.1.106:1521/orcl

(2) Table mode: export the data of the specified table.

Exp jl_bhps/abc123@192.168.1.106: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/abc123@192.168.1.106:1521/orcl file=d:temp/1.dmp log=d:temp/1.log

(4) full database method: export / import all objects in the data (log in using administrator account)

Exp system/abc123@192.168.1.106:1521/orcl file=d:temp/1.dmp log=d:temp/1.log full=y

Data Import of Oracle

(1) prompt mode for importing data:

Imp jl_bhps/abc123@192.168.1.106:1521/orcl

(2) Import a table or tables.

Imp jl_bhps/abc123@192.168.1.106:1521/orcl file=d:temp/1.dmp log=d:temp/1.log tables=emp,dept fromuser=scott touser=jl_bhps commit=y ignore=y

(3) Import the table under the user

Imp jl_bhps/abc123@192.168.1.106: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/abc123@192.168.1.106:1521/orcl file=d:temp/1.dmp log=d:temp/1.log full=y ignore=y destroy=y

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.