oracle建立表空间和数据库用户

win系统：

运行-cmd

sqlplus /nolog

conn /as sysdba;

linux系统：

su - oracle

sqlplus /nolog

conn /as sysdba;

建立表空间：

create tablespace SZTJ datafile 'F:\oracle\product\10.2.0\db_1\oradata\SZTJ.dmp'
size 50M 
autoextend on next 50M 
maxsize unlimited 
extent management local autoallocate 
segment space management auto; 

建立数据库用户

select username,default_tablespace from dba_users;
create user talkie identified by tjkjqaz;
alter user talkie default tablespace talkie;
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA,CONNECT,RESOURCE,CREATE SESSION TO talkie;

删除用户

drop user username cascade;