Oracle 导入导出SQL
时间:2022-03-14 03:42
1 导出 exp WEIXIN_WORK/WEIXIN_WORK@192.168.1.20:1521/orcl file=e:/db/weixin_work20141031_001.dmp buffer=10240 2 导入 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=10240 IMP XDAYWEIXIN/XDAYWEIXIN@192.168.1.20:1521/orcl file=e:/db/XDAY20141209.dmp fromuser=XDAYWEIXIN touser=XDAYWEIXIN