Oracle大量建立使用者和匯入匯出的指令碼

-- 在cmd下執行

SELECT 'exp ' || username || '/' || username || ' file=d:/' || username || '.dmp owner=' || username || ' log=d:/' ||
       username || '.txt'
  FROM dba_users
 WHERE account_status = 'OPEN';

-- 在被匯出庫執行，擷取語句後在匯出庫執行

SELECT 'create user ' || username ||' identified by ' || username || ' default tablespace ' || default_tablespace || ' temporary tablespace ' || temporary_tablespace || ';'
  FROM dba_users
 WHERE account_status = 'OPEN';

SELECT 'grant dba to ' || username || ';' FROM dba_users WHERE account_status = 'OPEN';

-- 在cmd下執行

SELECT 'imp ' || username || '/' || username || ' file=d:/' || username || '.dmp fromuser=' || username || ' touser=' ||
       username || ' ignore=y log=d:/' || username || '_imp.txt'
  FROM dba_users
 WHERE account_status = 'OPEN';