http://chaoji-liangbin.blog.163.com/blog/static/2523921220108272539140/
建立默认表空间
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