目录

Oracle 解决错误:ORA-25153: Temporary Tablespace is Empty

出现问题的根源在于临时表空间文件没有挂载,我们将其挂载上去就可以了。

如何查看表空间临时文件是否挂载

SELECT TABLESPACE_NAME,FILE_NAME FROM DBA_TEMP_FILES;

执行以上代码,显示结果如下:

以上结果表示 表空间 是成功挂载的

Oracle 如何挂载临时表空间

ALTER TABLESPACE TEMP ADD TEMPFILE 'C:/app/Administrator/oradata/DOCARE/TEMP01.DBF';

执行以上代码即可,其中的 TEMP01.DBF 文件为你自己程序的 Oracle 数据库文件路径,如果不知道在哪里,Windows 可以用磁盘搜索工具进行相应的搜索, Linux 可以用 Find 命令来搜索一下,很快就能找到。

至此大功告成。


上一篇:«

下一篇: »


评论


Warning: Undefined variable $req in /www/wwwroot/wxzzz.com/wp-content/themes/quirk-wordpress-theme-master/functions.php on line 232

Warning: Undefined variable $commenter in /www/wwwroot/wxzzz.com/wp-content/themes/quirk-wordpress-theme-master/functions.php on line 233

Warning: Trying to access array offset on value of type null in /www/wwwroot/wxzzz.com/wp-content/themes/quirk-wordpress-theme-master/functions.php on line 233

Warning: Undefined variable $aria_req in /www/wwwroot/wxzzz.com/wp-content/themes/quirk-wordpress-theme-master/functions.php on line 233

Warning: Undefined variable $req in /www/wwwroot/wxzzz.com/wp-content/themes/quirk-wordpress-theme-master/functions.php on line 236

Warning: Undefined variable $commenter in /www/wwwroot/wxzzz.com/wp-content/themes/quirk-wordpress-theme-master/functions.php on line 237

Warning: Trying to access array offset on value of type null in /www/wwwroot/wxzzz.com/wp-content/themes/quirk-wordpress-theme-master/functions.php on line 237

Warning: Undefined variable $aria_req in /www/wwwroot/wxzzz.com/wp-content/themes/quirk-wordpress-theme-master/functions.php on line 238

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注