oracle sql建立表空间,Oracle建立用户与表空间（SQL语句）

建立默认表空间

CREATE SMALLFILE TABLESPACE GDRADIOEPM DATAFILE 'D:/oracle/product/10.1.0/oradata/GISDATA/GDRADIOEPM' SIZE 100M  AUTOEXTEND ON NEXT 100M MAXSIZE 2000M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

建立临时表空间

CREATE SMALLFILE TEMPORARY TABLESPACE GDRADIOEPM_TEMP TEMPFILE 'D:/oracle/product/10.1.0/oradata/GISDATA/GDRADIOEPM_TEMP' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 1000M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M ;

创建用户并赋予权限

用户名：gdradioepm

密码：123456

密码：123456

SQL语句为

CREATE USER gdradioepm PROFILE "DEFAULT" IDENTIFIED BY 123456 DEFAULT TABLESPACE GDRADIOEPM TEMPORARY TABLESPACE GDRADIOEPM_TEMP ACCOUNT UNLOCK;

GRANT UNLIMITED TABLESPACE TO gdradioepm;

GRANT "CONNECT" TO gdradioepm;

GRANT "RESOURCE" TO gdradioepm;

并赋上system用户导入其他用户的sql语句：

imp system/system file=e:/CCS20100525.dmp fromuser=GDCCS20091221 touser=GDCCS20091221