整理oracle10g建立表空间、用户、导入dmp数据一系..
时间：2010-07-01 来源：biganer2008
--建立名为sulfur的profile，如果已存在不需要再次建立
create profile sulfur limit
sessions_per_user unlimited
cpu_per_session unlimited
cpu_per_call unlimited
connect_time unlimited
idle_time 60
logical_reads_per_session unlimited
logical_reads_per_call unlimited
private_sga unlimited
composite_limit unlimited;
--建立表空间
CREATE tablespace sulfur DATAFILE 'E:oracle_table_sulfur_data.dbs' SIZE 100M
DEFAULT STORAGE(
INITIAL 409600
NEXT 51200
MINEXTENTS 1
MAXEXTENTS unlimited
PCTINCREASE 1
)
ONLINE; --建立临时表空间
CREATE TEMPORARY TABLESPACE sulfur_data_tmp
TEMPFILE 'E:oracle_table_sulfur_data_tmp.dbs' SIZE 50M EXTENT
MANAGEMENT LOCAL UNIFORM SIZE 1M;
--建立用户
create user sulfur identified by sulfur default tablespace sulfur
temporary tablespace sulfur_data_tmp
quota unlimited on sulfur
quota 10M on system
profile sulfur;
alter user sulfur account unlock;
grant connect, resource to sulfur; imp sulfur/sulfur@ora10g owner=sulfur file=e:\q.dmp 导入数据，可能是安装oracle 10g 安装的有问题，报错imp.exe文件找不到。所以只能找到imp.exe文件后，通过它导入。
create profile sulfur limit
sessions_per_user unlimited
cpu_per_session unlimited
cpu_per_call unlimited
connect_time unlimited
idle_time 60
logical_reads_per_session unlimited
logical_reads_per_call unlimited
private_sga unlimited
composite_limit unlimited;
--建立表空间
CREATE tablespace sulfur DATAFILE 'E:oracle_table_sulfur_data.dbs' SIZE 100M
DEFAULT STORAGE(
INITIAL 409600
NEXT 51200
MINEXTENTS 1
MAXEXTENTS unlimited
PCTINCREASE 1
)
ONLINE; --建立临时表空间
CREATE TEMPORARY TABLESPACE sulfur_data_tmp
TEMPFILE 'E:oracle_table_sulfur_data_tmp.dbs' SIZE 50M EXTENT
MANAGEMENT LOCAL UNIFORM SIZE 1M;
--建立用户
create user sulfur identified by sulfur default tablespace sulfur
temporary tablespace sulfur_data_tmp
quota unlimited on sulfur
quota 10M on system
profile sulfur;
alter user sulfur account unlock;
grant connect, resource to sulfur; imp sulfur/sulfur@ora10g owner=sulfur file=e:\q.dmp 导入数据，可能是安装oracle 10g 安装的有问题，报错imp.exe文件找不到。所以只能找到imp.exe文件后，通过它导入。
相关阅读 更多 +
