当前位置:网站首页>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
边栏推荐
- Playwright controls local Google browsing to open and download files
- Vscode tips
- @Excellent you! CSDN College Club President Recruitment!
- [tensorflow] sharing mechanism
- Android clear app cache
- “湘见”技术沙龙 | 程序员&CSDN的进阶之路
- Analysis of the latest Android high frequency interview questions in 2020 (BAT TMD JD Xiaomi)
- 这个SQL语名是什么意思
- Tangent space
- Error 403 in most cases, you or one of your dependencies are requesting
猜你喜欢
Explanation of input components in Chapter 16
[quick platoon] 215 The kth largest element in the array
“湘见”技术沙龙 | 程序员&CSDN的进阶之路
[Journal Conference Series] IEEE series template download guide
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
Stack protector under armcc / GCC
Cross carbon market and Web3 to achieve renewable transformation
浅谈js正则之test方法bug篇
Solve the problem that Oracle needs to set IP every time in the virtual machine
9419 page analysis of the latest first-line Internet Android interview questions
随机推荐
Solve the problem that Oracle needs to set IP every time in the virtual machine
Riscv MMU overview
【重心坐标插值、透视矫正插值】原理以及用法见解
The difference between string and character array in C language
Ai21 labs | standing on the shoulders of giant frozen language models
Tersus notes employee information 516 MySQL query (time period uniqueness judgment of 2 fields)
Error 403 in most cases, you or one of your dependencies are requesting
100000 college students have become ape powder. What are you waiting for?
[point cloud series] pointfilter: point cloud filtering via encoder decoder modeling
TCP reset Gongji principle and actual combat reproduction
[point cloud series] deepmapping: unsupervised map estimation from multiple point clouds
Oracle generates millisecond timestamps
“湘见”技术沙龙 | 程序员&CSDN的进阶之路
零拷贝技术
Launcher hides app icons that do not need to be displayed
解决tp6下载报错Could not find package topthink/think with stability stable.
[dynamic programming] 221 Largest Square
Isparta is a tool that generates webp, GIF and apng from PNG and supports the transformation of webp, GIF and apng
MySQL 8.0.11 download, install and connect tutorials using visualization tools
Personal learning related