创建表空间 CREATE TABLESPACE TBS_LRM_DATA LOGGING DATAFILE 'D:/app/datebase/TBS_LRM_DATA.dbf' SIZE 1024M AUTOEXTEND ON NEXT 50M MAXSIZE 10240M EXTENT MANAGEMENT LOCAL; 创建用户 权限 create user lpm_cd identified by lpm default tablespace TBS_LRM_DATA; grant connect,dba,resource to lpm_cd; 导出数据库dmp 文件 @bj 本地配置文件 exp zhongdian/lpm@bj file=D:/lpm_cd_0105.dmp owner=zhongdian 导入数据库文件 imp lpm_cd/lpm@ORCL file=D:\app\lpm2.dmp full=y; |
|
来自: 柳7it48xq2tc7q > 《Oracle》