oracle常用命令总结一(二)

exp demo/demo@orcl file=f:/backup_test.dmpfull=y

imp demo/demo@orcl file=f:/backup_test.dmpfull=y ignore=y

-- Create database link
create database link mydblink
connect to BRUCE identified by "123456";
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.126)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test1)
)
)';

以上是部分常用命令，不过还有好多，也有很多大牛总结的比我好很多，还望大家见谅，未完待续...