当前位置:网站首页>Oracle modify default temporary tablespace
Oracle modify default temporary tablespace
2022-04-23 13:41:00 【Wangcai 2】
-- Create a temporary table space
create temporary tablespace wdy_temp
tempfile 'D:\oracle\app\oracle\oradata\XE\wdy_temp.DBF'
size 50m
autoextend on
next 50m maxsize unlimited
extent management local;
-- Modify the default table space to the new temporary table space
alter database default temporary tablespace temp01;
-- View the temporary tablespace currently used by the user
select username,temporary_tablespace from dba_users;
-- Delete the original temporary tablespace
drop tablespace temp including contents and datafiles;
-- Check all tablespace names and confirm whether the temporary tablespace has been deleted
select tablespace_name from dba_tablespaces;
Expand :
-- Add data files to temporary tablespaces
alter tablespace temp01 add tempfile '/oradata/temp02.dbf' size 2G autoextend on;
-- Modify temporary tablespace data file size
alter database tempfile '/oradata/temp02.dbf' resize 4G;
版权声明
本文为[Wangcai 2]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204230604300659.html
边栏推荐
- innobackupex增量备份
- 切线空间(tangent space)
- 交叉碳市场和 Web3 以实现再生变革
- [point cloud series] multi view neural human rendering (NHR)
- Error 403 in most cases, you or one of your dependencies are requesting
- 【视频】线性回归中的贝叶斯推断与R语言预测工人工资数据|数据分享
- Zero copy technology
- Is Hongmeng system plagiarism? Or the future? Professional explanation that can be understood after listening in 3 minutes
- 你和42W奖金池,就差一次“长沙银行杯”腾讯云启创新大赛!
- kettle庖丁解牛第16篇之输入组件周边讲解
猜你喜欢
榜样专访 | 孙光浩:高校俱乐部伴我成长并创业
面试官给我挖坑:URI中的 “//” 有什么用?
你和42W奖金池,就差一次“长沙银行杯”腾讯云启创新大赛!
You and the 42W bonus pool are one short of the "Changsha bank Cup" Tencent yunqi innovation competition!
Example of specific method for TIA to trigger interrupt ob40 based on high-speed counter to realize fixed-point machining action
TIA博途中基于高速计数器触发中断OB40实现定点加工动作的具体方法示例
QT调用外部程序
Detailed explanation of constraints of Oracle table
校园外卖系统 - 「农职邦」微信原生云开发小程序
Example interview | sun Guanghao: College Club grows and starts a business with me
随机推荐
Launcher hides app icons that do not need to be displayed
Publish custom plug-ins to local server
Oracle defines self incrementing primary keys through triggers and sequences, and sets a scheduled task to insert a piece of data into the target table every second
Summary of request and response and their ServletContext
Isparta is a tool that generates webp, GIF and apng from PNG and supports the transformation of webp, GIF and apng
Oracle renames objects
Servlet of three web components
[point cloud series] full revolutionary geometric features
Personal learning related
The difference between string and character array in C language
Operations related to Oracle partition
Oracle lock table query and unlocking method
Machine learning -- model optimization
TCP reset Gongji principle and actual combat reproduction
你和42W奖金池,就差一次“长沙银行杯”腾讯云启创新大赛!
9419 page analysis of the latest first-line Internet Android interview questions
Zero copy technology
Comparison and summary of applicable scenarios of Clickhouse and MySQL database
5 tricky activity life cycle interview questions. After learning, go and hang the interviewer!
UEFI learning 01-arm aarch64 compilation, armplatformpripeicore (SEC)