以前做的一个测试,环境是windows server+oracle
新建cpfr库 set ORACLE_SID=cpfr
1、系统用户登录oracle
在命令模式下(cmd) 输入 : sqlplus / as sysdba;
2、查看表空间应该见在哪
select * from dba_data_files;
---创建临时表空间
create temporary tablespace D_CPFR
tempfile 'E:\oracle\product\10.2.0\oradata\cpfr\D_CPFR.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
---创建数据表空间
create tablespace T_D_CPFR
logging
datafile 'E:\oracle\product\10.2.0\oradata\cpfr\T_D_CPFR.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
2、新建用户
create user cpfr identified by test123 default tablespace T_D_CPFR temporary tablespace D_CPFR;
3、授权
grant connect,resource,dba to cpfr;
4、导入数据库(dos命令下)
imp cpfr/test123@cpfr file=E:\data-cpfr2014-10-31\backup\data-cpfr2014-10-31.dmp full=y;
新建cpfr库 set ORACLE_SID=cpfr
1、系统用户登录oracle
在命令模式下(cmd) 输入 : sqlplus / as sysdba;
2、查看表空间应该见在哪
select * from dba_data_files;
---创建临时表空间
create temporary tablespace D_CPFR
tempfile 'E:\oracle\product\10.2.0\oradata\cpfr\D_CPFR.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
---创建数据表空间
create tablespace T_D_CPFR
logging
datafile 'E:\oracle\product\10.2.0\oradata\cpfr\T_D_CPFR.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
2、新建用户
create user cpfr identified by test123 default tablespace T_D_CPFR temporary tablespace D_CPFR;
3、授权
grant connect,resource,dba to cpfr;
4、导入数据库(dos命令下)
imp cpfr/test123@cpfr file=E:\data-cpfr2014-10-31\backup\data-cpfr2014-10-31.dmp full=y;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29438041/viewspace-1727987/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29438041/viewspace-1727987/