Oracle 匯入匯出SQL

標籤：blog   資料   div   2014   log   as   tt   sql   br   

1 匯出exp WEIXIN_WORK/[email protected]:1521/orcl file=e:/db/weixin_work20141031_001.dmp  buffer=102402 匯入   IMP WEIXIN_WORK/[email protected]: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/[email protected]:1521/orcl file=e:/XDAY20141209.dmp  buffer=10240IMP XDAYWEIXIN/[email protected]:1521/orcl file=e:/db/XDAY20141209.dmp fromuser=XDAYWEIXIN touser=XDAYWEIXIN

　　

Oracle 匯入匯出SQL