1 导出
exp WEIXIN_WORK/WEIXIN_WORK@192.168.1.20:1521/orcl file=e:/db/weixin_work20141031_001.dmp buffer=10240
--注意结尾不能加分号;
2 导入
IMP HLMARKET/HLMARKET@192.168.1.22:1521/orcl file=e:/db/HLMARKET_20150729.dmp fromuser=HLMARKET touser=HLMARKET tablespaces=HLMARKET_DATA log=e:/db/HLMARKET.txt
-- 执行数据表为空的数据表结构
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;
exp XDAYWEIXIN/XDAYWEIXIN@192.168.1.20:1521/orcl file=e:/XDAY20141209.dmp buffer=10240
IMP XDAYWEIXIN/XDAYWEIXIN@192.168.1.20:1521/orcl file=e:/db/XDAY20141209.dmp fromuser=XDAYWEIXIN touser=XDAYWEIXIN
3 查看登录用户下表个数
select count(table_name) from user_tables ;