Oracle创建数据库

微风吹过的夏天2016

已于 2024-08-15 13:57:25 修改

阅读量267

点赞数 4

文章标签：数据库 oracle

于 2024-08-06 15:50:54 首次发布

本文链接：https://blog.csdn.net/beijing20110905/article/details/140957988

版权

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

create tablespace KJGH datafile 'D:\devtool\oracle11\oradata\orcl\KJGH4101.dbf' size 128M reuse autoextend on next 16K maxsize unlimited extent management local autoallocate;

create temporary tablespace KJGHTEMP tempfile 'D:\devtool\oracle11\oradata\orcl\KJGHTEMP01.dbf' size 64M reuse autoextend on next 1024K MAXSIZE 2048M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;

create user KJGH identified by prdct default tablespace KJGH temporary tablespace KJGHTEMP quota unlimited on KJGH;

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

imp KJGH/KJGH@ORCLlocal fromuser=KJGH touser=KJGH file=E:\项目文件\123.dmp
ORCLlocal是你在tnsnames.ora的名称