1 导出exp WEIXIN_WORK/WEIXIN_WORK@192.168.1.20:1521/orcl file=e:/db/weixin_work20141031_001.dmp  buffer=102402 导入   IMP WEIXIN_WORK/WEIXIN_WORK@127.0.0.1:1521/orcl file=e:/db/weixin_work20140829_001.dmp fromuser=WEIXIN_WORK touser=WEIXIN_WORK -- 执行数据表为空的数据表结构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=10240IMP XDAYWEIXIN/XDAYWEIXIN@192.168.1.20:1521/orcl file=e:/db/XDAY20141209.dmp fromuser=XDAYWEIXIN touser=XDAYWEIXIN