表空间(上)
4.直接修改表空间扩容： （1）一般表空间： 自动扩展： alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend on; 关闭自动扩展：alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend off; 指定大小： alter
4.直接修改表空间扩容：
（1）一般表空间：
自动扩展： alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend on;
关闭自动扩展：alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend off;
指定大小： alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' resize 50m;
（2）临时表空间
自动扩展： alter database tempfile '/oracle/app/oradata/tbs_temp_ptcl.dbf' autoextend on;
关闭自动扩展：alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend off;
指定大小： alter database tempfile '/oracle/app/oradata/tbs_temp_ptcl.dbf' resize 50m;
（3）扩容后查找语句：
select * from dba_tablespaces a where a.tablespace_name like '%PTCL';
5.为表空间添加新的数据文件
（1）一般表空间：
指定大小： alter tablespace tbs_sys_ptcl add datafile '/oracle/oradata/ora242/YM_tbs/tbs_sys_ptcl.ora' size 50M ;
自动扩展 alter tablespace tbs_sys_ptcl add datafile '/oracle/oradata/ora242/YM_tbs/tbs_sys_ptcl.ora' size 50M
autoextend on;
（2）临时表空间
指定大小：alter tablespace tbs_temp_ptcl add tempfile '/oracle/oradata/ora242/YM_tbs/tbs_temp_ptcl.dbf' size 50M;
自动扩展：alter tablespace tbs_temp_ptcl add tempfile '/oracle/oradata/ora242/YM_tbs/tbs_temp_ptcl.dbf' size 50M
autoextend on;
6. 删出用户及其表空间：
(1)删掉用户：
drop user lbi_sys_ptcl cascade;
(2)删掉表空间：
drop tablespace TBS_SYS_PTCL including contents and datafiles CASCADE CONSTRAINTS ;
（3)删掉数据文件：
alter database datafile '/oracle/oradata/ora242/YM_tbs/TBS_DW_YM.ora' offline drop;
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to change the personal name in the group on DingTalk_How to modify the personal name in the group on DingTalk
Mar 29, 2024 pm 08:41 PM
1. First open DingTalk. 2. Open the group chat and click the three dots in the upper right corner. 3. Find my nickname in this group. 4. Click to enter to modify and save.
Can Douyin Blue V change its name? What are the steps to change the name of corporate Douyin Blue V account?
Mar 22, 2024 pm 12:51 PM
Douyin Blue V certification is the official certification of a company or brand on the Douyin platform, which helps enhance brand image and credibility. With the adjustment of corporate development strategy or the update of brand image, the company may want to change the name of Douyin Blue V certification. So, can Douyin Blue V change its name? The answer is yes. This article will introduce in detail the steps to modify the name of the enterprise Douyin Blue V account. 1. Can Douyin Blue V change its name? You can change the name of Douyin Blue V account. According to Douyin’s official regulations, corporate Blue V certified accounts can apply to change their account names after meeting certain conditions. Generally speaking, enterprises need to provide relevant supporting materials, such as business licenses, organization code certificates, etc., to prove the legality and necessity of changing the name. 2. What are the steps to modify the name of corporate Douyin Blue V account?
Win10 sleep time modification tips revealed
Mar 08, 2024 pm 06:39 PM
Win10 Sleep Time Modification Tips Revealed As one of the currently widely used operating systems, Windows 10 has a sleep function to help users save power and protect the screen when not using the computer. However, sometimes the default sleep time does not meet the needs of users, so it is particularly important to know how to modify the Win10 sleep time. This article will reveal the tips for modifying the sleep time of Win10, allowing you to easily customize the system’s sleep settings. 1. Modify Win10 sleep time through “Settings” First, the simplest fix
Extensions and third-party modules for PHP functions
Apr 13, 2024 pm 02:12 PM
To extend PHP function functionality, you can use extensions and third-party modules. Extensions provide additional functions and classes that can be installed and enabled through the pecl package manager. Third-party modules provide specific functionality and can be installed through the Composer package manager. Practical examples include using extensions to parse complex JSON data and using modules to validate data.
Automount drives on Linux
Mar 20, 2024 am 11:30 AM
If you are using a Linux operating system and want the system to automatically mount the drive on boot, you can do this by adding the device's unique identifier (UID) and mount point path to the fstab configuration file. fstab is a file system table file located in the /etc directory. It contains information about the file systems that need to be mounted when the system starts. By editing the fstab file, you can ensure that the required drives are loaded correctly every time the system starts, thus ensuring stable system operation. Automatically mounting drivers can be conveniently used in a variety of situations. For example, I plan to back up my system to an external storage device. To achieve automation, ensure that the device remains connected to the system, even at startup. Likewise, many applications will directly
How to modify the address location of published products on Xianyu
Mar 28, 2024 pm 03:36 PM
When publishing products on the Xianyu platform, users can customize the geographical location information of the product according to the actual situation, so that potential buyers can more accurately grasp the specific location of the product. Once the product is successfully put on the shelves, there is no need to worry if the seller's location changes. The Xianyu platform provides a flexible and convenient modification function. So when we want to modify the address of a published product, how do we modify it? This tutorial guide will provide you with a detailed step-by-step guide. I hope it can help. Everyone! How to modify the release product address in Xianyu? 1. Open Xianyu, click on what I published, select the product, and click Edit. 2. Click the positioning icon and select the address you want to set.
How to modify the greeting content for boss direct recruitment
Mar 01, 2024 pm 03:40 PM
In the job recruitment software called Boss Direct Jobs, users can personalize their greetings to better demonstrate their personality and job search intentions. However, sometimes the default greeting terms are rather mechanical and rigid. Many users want to make their own changes but don’t know where to set them. So this tutorial guide will introduce the detailed modification steps for players who want to know more. Come and follow this article to find out! How to change the answer when a boss directly hires someone to say hello: [Boss directly hires]-[My]-[Settings Icon]-[Greeting Language]. Specific steps: 1. First, we click on the boss direct recruitment software. After entering the homepage, we click [My] in the lower right corner; 2. Then when we come to the My page, we can see the relevant data.
Go Language Programming Guide: Implementation of Modifying Hosts File
Mar 07, 2024 am 10:51 AM
Title: Go Language Programming Guide: Implementation of Modifying the Hosts File In the daily software development process, we often encounter situations where we need to modify the hosts file in the operating system. The Hosts file is a text file without extension used to map IP addresses and host names. It is usually used to set up domain name resolution locally. In this article, we will introduce how to use the Go language to implement the function of modifying the hosts file of the operating system, and give specific code examples. First, we need to create a G that can modify the hosts file
