|
創(chuàng)建表空間 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; 創(chuàng)建用戶 權(quán)限 create user lpm_cd identified by lpm default tablespace TBS_LRM_DATA; grant connect,dba,resource to lpm_cd; 導(dǎo)出數(shù)據(jù)庫dmp 文件 @bj 本地配置文件 exp zhongdian/lpm@bj file=D:/lpm_cd_0105.dmp owner=zhongdian 導(dǎo)入數(shù)據(jù)庫文件 imp lpm_cd/lpm@ORCL file=D:\app\lpm2.dmp full=y； |
|
|
