Linux环境下oracle创建和删除表空间及用户
#su – oracle
$ sqlplus /nolog
SQL> connect / as sysdba
–//创建临时表空间
create temporary tablespace myuser_temp
tempfile '/home/oracle/storage/myuser_temp01.dbf'
size 64m
autoextend on
next 64m maxsize 2[……]
转帖,吐槽,乱扯
#su – oracle
$ sqlplus /nolog
SQL> connect / as sysdba
–//创建临时表空间
create temporary tablespace myuser_temp
tempfile '/home/oracle/storage/myuser_temp01.dbf'
size 64m
autoextend on
next 64m maxsize 2[……]