oracle导库脚本

--1、创建表空间
CREATE BIGFILE TABLESPACE "xx" 
    LOGGING 
    DATAFILE 'H:\oracledata\xx.ora' SIZE 500M
    AUTOEXTEND 
    ON NEXT  100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL 
    SEGMENT SPACE MANAGEMENT  AUTO ;
    
DROP TABLESPACE "xx" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; 
  
--2.创建用户 
CREATE USER  "xx" PROFILE "DEFAULT" 
    IDENTIFIED BY "xx" DEFAULT TABLESPACE "xx"
    TEMPORARY TABLESPACE "TEMP" 
    ACCOUNT UNLOCK; 
GRANT UNLIMITED TABLESPACE TO "xx";
GRANT "CONNECT" TO "xx";
GRANT "DBA" TO "xx";
GRANT "RESOURCE" TO "xx";


--删除用户命令
drop user xx cascade;




--3、导入
imp xx/xx@ORCL file=H:\dbback\db\xx.dmp ignore=y fromuser=xx touser=xx log=H:\oracledata\xx.log buffer=128000 statistics=none commit=y