当前位置:网站首页>oracle创建表空间和修改用户默认表空间
oracle创建表空间和修改用户默认表空间
2022-04-23 06:04:00 【旺财2】
--表空间
--不限制表空间大小用:maxsize unlimited
create tablespace wdy_data
logging
datafile 'D:\oracle\app\oracle\oradata\XE\wdy_data.DBF'
size 50m
autoextend on
next 50m maxsize 1024m
extent management local;
--创建临时表空间
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;
--2.建用户
create user user_wdy2 identified by user_wdy2_123456
default tablespace wdy_data
temporary tablespace wdy_temp;
--3.赋权
grant connect,resource to user_wdy2;
grant create any sequence to user_wdy2;
grant create any table to user_wdy2;
grant delete any table to user_wdy2;
grant insert any table to user_wdy2;
grant select any table to user_wdy2;
grant unlimited tablespace to user_wdy2;
grant execute any procedure to user_wdy2;
grant update any table to user_wdy2;
grant create any view to user_wdy2;
--4.修改用户默认表空间:
alter user user_wdy2 default tablespace wdy_data
版权声明
本文为[旺财2]所创,转载请带上原文链接,感谢
https://blog.csdn.net/wdyliuxingfeiyang/article/details/122038019
边栏推荐
- Research on alertmanager repeated / missing alarm phenomenon and two key parameters_ Wait and group_ Interpretation of interval
- Analysis of Rdam principle
- 异常记录-18
- BPF program of type XDP
- Typical application scenarios of alicloud log service SLS
- Dolphinscheduler调度spark任务踩坑记录
- oracle存储过程中is和as区别
- Dolphinscheduler配置Datax踩坑记录
- 异常记录-11
- switch case时连写常规判断表达式的错误 case和if并用 l
猜你喜欢
Introduction to DDoS attack / defense
Implementation of multi tenant read and write in Prometheus cortex
Ali vector library Icon tutorial (online, download)
Dolphinscheduler配置Datax踩坑记录
Apache SeaTunnel 2.1.0部署及踩坑
Dolphinscheduler集成Flink任务踩坑记录
阿里矢量库的图标使用教程(在线,下载)
High performance gateway for interconnection between VPC and IDC based on dpdk
Analysis of Rdam principle
oracle undo使用率高问题处理
随机推荐
异常记录-15
冬季实战营动手实战-上云必备环境准备,动手实操快速搭建LAMP环境 领鼠标 云小宝 背包 无影
Thanos Compact组件测试总结(处理历史数据)
使用prom-label-proxy实现Prometheus Thanos的基于标签的多租户读
Thanos compact component test summary (processing historical data)
Prometheus的relabel_configs和metric_relabel_configs解释及用法示例
Research on alertmanager repeated / missing alarm phenomenon and two key parameters_ Wait and group_ Interpretation of interval
Ansible basic commands, roles, built-in variables and tests judgment
Oracle redo log产生量大的查找思路与案例
关于Postgres主从复制延迟监控的错误告警问题
Abnormal record-21
双指针仪表盘读数(一)
prometheus告警记录持久化(历史告警保存与统计)
js 格式化当前时间 日期推算
Winter combat camp hands-on combat - cloud essential environment preparation, hands-on practical operation, quickly build lamp environment, lead mouse cloud Xiaobao backpack without shadow
oracle undo使用率高问题处理
冬季实战营 动手实战-初识上云基础,动手实操ECS云服务器新手上路 领鼠标 云小宝 背包 无影
RAC环境报错ORA-00239: timeout waiting for control file enqueue排查
一个DG环境的ORA-16047: DGID mismatch between destination setting and target database问题排查及监听VNCR特性
阿里矢量库的图标使用教程(在线,下载)