oracle表空间创建及用户创建、表空间自动扩展

数据库配置文件已经安装到D:\oracle\product\10.2.0,同时其他选定的安装组件也已经安装到D:\oracle\product\10.2.0\db_1

create tablespace GRP

datafile 'D:\oracle\product\10.2.0\oradata\orcl\GRP.DBF' size 500M

autoextend on next 100M maxsize 2048m logging

extent management local autoallocate

segment space management auto;

create temporary tablespace GRP_TEMP

tempfile 'D:\oracle\product\10.2.0\oradata\orcl\GRP_temp.dbf'

size 50m

autoextend on

next 50m maxsize 2048m

extent management local;

create user username identified by password

default tablespace GRP

temporary tablespace GRP_TEMP;

grant connect,resource,dba to gaosun;

导入dmp文件

imp 用户名/密码@sid file = .dmp文件路径

oracle 表空间自动扩展

alter database datafile 'D:\oracle\product\10.2.0\oradata\orcl\GRP.DBF' autoextend on next 100m maxsize 10000m