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

The usage of EXP and IMP

Exp username / password @ database connection address file= export file path

Imp username / password @ database connection address file= import file path ignore=y

For example: imp scott/abcd@127.0.0.1:1521/orcl file=D:\ backup\ scott.dmp tables= (emp,dept)

You can use the tnsping command to test whether you can connect to the database

For example: tnsping ORCL (PS: where ORCL is the name of a monitor)

Tnsping 127.0.0.1:1521/orcl

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

Reference: http://www.2cto.com/database/201305/210262.html

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.