oracle 导入、导出；创建表空间和用户并授权

s73n4umzgy

　　



--oracle导出语句
exp system/manager@lmis file=F:\数据库\dd.dmp full=y log=F:\dd.log owner=dd 

connect system/manager
---创建表空间(lz表空间)-----
CREATE TABLESPACE lz_data DATAFILE 'D:\oracle\product\10.2.0\oradata\lz_data.dbf' SIZE 1000M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;


---创建用户（lz用户）
CREATE USER lz  PROFILE DEFAULT IDENTIFIED BY lz
DEFAULT TABLESPACE lz_data TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;


--授权
GRANT CONNECT,RESOURCE,DBA TO lz WITH ADMIN OPTION;
GRANT CREATE TABLE TO lz;
GRANT CREATE TRIGGER TO lz;
ALTER USER lz DEFAULT ROLE  ALL;
grant select any table to lz;
grant alter any table to lz;

--oracle导入语句：
imp system/manager file = d:\20090718.dmp fromuser = dd,dx,hei touser = dd,dx,hei ignore = y log = c:\usr.log buffer=2048000