Linux Oracle 创建用户1、启动Oracle(Oracle没启动的情况下)su-oracle,切换成oracle用户lsnrctlstartsqlplus/nologconn/assysdbastartup(若数据库处于启动状态,则无需再次启动)2、查询临时表空间和表空间的存储位置selectnamefromv$tempfile;selectnamefromv$datafile从结果可以看出有…
create temporary tablespace jason_temp tempfile ‘/oracle/u02/oradata/ERP2/jason_temp.dbf’ size 100m reuse autoextend on next 20m maxsize unlimited;
create tablespace jason datafile ‘/oracle/u02/oradata/ERP2/jason.dbf’ size 100M reuse autoextend on next 40M maxsize unlimited default storage(initial 128k next 128k minextents 2 maxextents unlimited);
注:删除表空间的命令drop tablespace temp including contents and datafiles;
4、创建用户并指定表空间
create user jason identified by jason default tablespace jason temporary tablespace jason_temp;