一、导出
[root@localhost ~]$ cd /opt/dmdbms/bin
(1)FULL方式导出整个数据库
FULL=Y
[root@localhost bin]$ ./dexp USERID=YWB/ywb990320 FILE=db_test.dmp LOG=test.log FULL=Y DIRECTORY=/opt/dmdbms/data/dexp/
(2)OWNER方式导出一个或多个用户拥有的所有对象
OWNER=<用户名>{,<用户名>}
[root@localhost bin]$ ./dexp USERID=SYSDBA/SYSDBA FILE=db_test_02.dmp LOG=db_test_02.log OWNER=YWB DIRECTORY=/opt/dmdbms/data/dexp/
#导出用户ywb的所有对象
(3)TABLES方式导出一个或多个指定的表或表分区,导出所有数据行、约束、索引等信息
[root@localhost bin]$ ./dexp USERID=YWB/ywb990320 FILE=db_test_03.dmp LOG=db_test_03.log TABLES=test DIRECTORY=/opt/dmdbms/data/dexp/
#导出名为test的这张表
二、导入
(1)FULL
[root@localhost bin]# ./dimp USERID=SYSDBA/SYSDBA FILE=/opt/dmdbms/data/dexp/db_test.dmp LOG=db_test.log FULL=Y DIRECTORY=/opt/dmdbms/data/dimp
(2)OWNER
[root@localhost bin]# ./dimp USERID=YWB/ywb990320 FILE=/opt/dmdbms/data/dexp/db_test_02.dmp LOG=db_test_02.log OWNER=YWB DIRECTORY=/opt/dmdbms/data/dimp/
(3)TABLES
[root@localhost bin]$ ./dimp USERID=YWB/ywb990320 FILE=/opt/dmdbms/data/dexp/db_test_03.dmp LOG=db_test_03.log TABLES=test DIRECTORY=/opt/dmdbms/data/dimp/