导出数据事列 :
参考: http://blog.csdn.net/luwei_cool/article/details/50790672
exp amtest/123456@junhe_Office file=d:\11daochu.dmp --- 导出
imp junhe/123456@ORCL file=d:\11daochu.dmp full=y -- 导入
1.如果碰到空表则执行如下语句:
select 'alter table '||table_name||' allocate extent;' from user_tables t where t.NUM_ROWS = 0 or t.NUM_ROWS is null;
将结果: 执行, 空表就可以导出了
2.修改地址源
C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\ tnsnames.ora
junhe_Office =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.199.15)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
3.导出 表结构
exp amtest/123456@junhe_Office file=d:\daochu.dmp rows=n -- 导出 表结构
范列: exp username/pwd@sid file=d:/data/bak.dmp owner=(user)rows=n
用exp命令导出表结构,不导出表数据。只需在命令行里加一个参数rows=n即可。表示不导出表数据。