82855 AI Apple Watch CentOS Eclipse H700 iCal iOS iPad iPhone iphone4 iTunes Java Javascript linux Mac MBP ML MySQL Oracle OS X Parallels Desktop RAID redmine Rocky Linux Snow Leopard SQL SVN Thinkpad VMware VR Windows Windows 7 Windows 11 Word X40 东航 压缩算法 字体 导航 数据库 朗逸 签证 达美 闹钟
Create tablespace TEMP2
datafile '/data1/ora9data/temp2_01.dbf'
size 100k TEMPORARY;
Tablespace created.
alter database default temporary tablespace TEMP2;
Database altered.
drop tablespace temp including contents and datafiles;
Tablespace dropped.
《“转移 Oracle 的TEMP表空间”》 有 1 条评论
新版本 oracle 创建 temp 的指令有变化
CREATE TEMPORARY tablespace TEMP2
TEMPFILE ‘C:\APP\ADMINISTRATOR\ORADATA\ORCL\TEMP02.DBF’
size 10M;