表空间

Jun 07, 2016 pm 04:06 PM
Check user space

1.查看某个用户对应的表空间和datafile select t1.username,t2.tablespace_name,t2.file_name,t1.temporary_tablespace ,t3.file_name from dba_users t1 left join dba_data_files t2 on t1.default_tablespace = t2.tablespace_name left join dba_temp_fi

1.查看某个用户对应的表空间和datafile
select t1.username,t2.tablespace_name,t2.file_name,t1.temporary_tablespace ,t3.file_name
from dba_users t1
left join
dba_data_files t2
on t1.default_tablespace = t2.tablespace_name
left join
dba_temp_files t3
on t1.temporary_tablespace = t3.tablespace_name
where
lower(t1.username) in
('lbi_sys_ptcl','lbi_ods_ptcl','lbi_ods_ptcl','lbi_edm_ptcl','lbi_ls_ptcl','lbi_dm_ptcl','lbi_dim_ptcl')

2.产看表空间信息:
(1)一般表空间查询
select * from dba_data_files t where t.tablespace_name in (
'TBS_DIM_PTCL','TBS_LS_PTCL', 'TBS_ODS_PTCL', 'TBS_DM_PTCL', 'TBS_EDM_PTCL', 'TBS_SYS_PTCL' );
(2)临时表空间查询
select * from dba_temp_files t where t.tablespace_name in ('TBS_TEMP_PTCL');

3.创建表空间
(1)一般表空间
create tablespace "TBS_DW_YM"
nologging
datafile '/opt/oracle/oradata/YM_tbs/TBS_DW_YM.dbf' size 50m
extent management local segment space management auto;
--extent management:区管理
--local segment space management :本地段空间管理
--auto 自动管理,一般默认情况就是,如果想改为手动管理:manual
(2)临时表空间
create
temporary tablespace "TBS_YM_TEMP"
tempfile '/opt/oracle/oradata/YM_tbs/TBS_YM_TEMP.dbf' size 50m
reuse autoextend on next 640k maxsize 1000M;
--reuse :重新运用,可以加可以不加

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to use Xiaohongshu account to find users? Can I find my mobile phone number? How to use Xiaohongshu account to find users? Can I find my mobile phone number? Mar 22, 2024 am 08:40 AM

How to use Xiaohongshu account to find users? Can I find my mobile phone number?

Log in to Ubuntu as superuser Log in to Ubuntu as superuser Mar 20, 2024 am 10:55 AM

Log in to Ubuntu as superuser

Check out the steps to delete a logged-in device on Douyin Check out the steps to delete a logged-in device on Douyin Mar 26, 2024 am 09:01 AM

Check out the steps to delete a logged-in device on Douyin

How to check your own ID on Xianyu_Introduction to how to check your personal nickname on Xianyu How to check your own ID on Xianyu_Introduction to how to check your personal nickname on Xianyu Mar 22, 2024 am 08:21 AM

How to check your own ID on Xianyu_Introduction to how to check your personal nickname on Xianyu

Analysis of user password storage mechanism in Linux system Analysis of user password storage mechanism in Linux system Mar 20, 2024 pm 04:27 PM

Analysis of user password storage mechanism in Linux system

Where to check music rankings on NetEase Cloud Music_How to check music rankings on NetEase Cloud Music Where to check music rankings on NetEase Cloud Music_How to check music rankings on NetEase Cloud Music Mar 25, 2024 am 11:40 AM

Where to check music rankings on NetEase Cloud Music_How to check music rankings on NetEase Cloud Music

How to view the hot list of Kuaishou Live Companion videos How to view the hot list of Kuaishou Live Companion videos Mar 29, 2024 pm 08:09 PM

How to view the hot list of Kuaishou Live Companion videos

How to check how many groups you have joined on WeChat: a simple step How to check how many groups you have joined on WeChat: a simple step Mar 26, 2024 am 10:06 AM

How to check how many groups you have joined on WeChat: a simple step

See all articles