82855 AI Apple Watch CentOS Eclipse H700 iCal iOS iPad iPhone iphone4 iTunes Java Javascript linux Mac MBP ML MySQL Oracle Parallels Desktop RAID redmine Rocky Linux RockyLinux screen 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;