oracle 新建表空间 新建库 新建用户

打开win32 命令行客户端

使用命令

sqlplus / as sysdba

登录：

select name from v$tempfile;
create temporary tablespace TPOS_TEMP tempfile 'C:\APP\ADMINISTRATOR\ORADATA\TPOSDB\TPOS_TEMP.bdf' size 100m reuse autoextend on next 20m maxsize unlimited;


select name from v$datafile;
create tablespace TPOS_DB datafile 'C:\APP\ADMINISTRATOR\ORADATA\TPOSDB\TPOS_DB.dbf' size 100M reuse autoextend on next 40M maxsize unlimited default storage(initial 128k next 128k minextents 2 maxextents unlimited);


create user tposdb_user identified by 123456789 default tablespaceTPOS_DB temporary tablespace TPOS_TEMP;


grant dba to tposdb_user;
grant connect,resource to tposdb_user;
grant select any table,delete any table,update any table,insert any table to tposdb_user;
grant create any view to tposdb_user;
grant create sequence,select any sequence to tposdb_user;