oracle imp exp 导入导出

 

===========================================

CREATE TABLE xue_sheng( id integer, xing_ming varchar(25));

INSERT INTO xue_sheng VALUES(1,'ZhanSan');

INSERT INTO xue_sheng VALUES(2,'LiSi');

COMMIT;

----------------------------------------------
下面开始进行备份： (备份学生表里的全部数据)

[oracle@localhost ~]$ exp scott/tiger    <- 这里输入账号

Export: Release 11.2.0.1.0 - Production on Thu Jul 15 05:30:10 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter arra