Oracle创建数据库

使用server上的sqlplus登录；
drop user KJGH41 cascade;
drop tablespace KJGH41 including contents;
drop tablespace KJGH41TEMP including contents;

create tablespace KJGH41 datafile 'D:\devtool\oracle11\oradata\orcl\KJGH4101.dbf' size 128M reuse autoextend on next 16K maxsize unlimited extent management local autoallocate; 
 
create temporary tablespace KJGH41TEMP tempfile 'D:\devtool\oracle11\oradata\orcl\KJGH41TEMP01.dbf' size 64M reuse autoextend on next 1024K MAXSIZE 2048M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K; 

create user KJGH41 identified by prdct default tablespace KJGH41 temporary tablespace KJGH41TEMP quota unlimited on KJGH41; 

grant connect, dba to KJGH41; 
grant select any table to KJGH41; 
grant delete any table to KJGH41; 
grant insert any table to KJGH41; 
grant update any table to KJGH41; 
grant execute any procedure to KJGH41;

imp KJGH41/KJGH41@ORCLlocal fromuser=KJGH41 touser=KJGH41 file=E:\项目文件\武汉市地籍调查示范点项目\数据库设计参考\深圳质检.dmp
ORCLlocal是你在tnsnames.ora的名称