原出处:http://blog.csdn.net/starnight_cbj/article/details/6792364#
1.获取权限:
sqlplus "/ as sysdba
2.创建表空间:
- CREATE TABLESPACE sdt _data
- DATAFILE 'F:\tablespace\sdt_data' size 800M
- EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
- --索引表空间
- CREATE TABLESPACE sdt_Index
- DATAFILE 'F:\tablespace\sdt_Index'size 512M
- EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
3.创建用户demo,并指定表空间:
- create user demo identified by 1
- default tablespace sdt _data;
4.用户赋权:
grant connect,resource,dba to demo ;
5.
导入导出命令:
- ip导出方式: exp demo/1@127.0.0.1:1521/orcl file=f:/f.dmp full=y
- exp demo/1@orcl file=f:/f.dmp full=y
- imp demo/1@orcl file=f:/f.dmp full=y ignore=y
6.补充:每换一次ip要对配置文件进行修改(net configuration assistance)。