ORA-01950: no privileges on tablespace xxxx
On No Tablespace xxxx ORA privileges
2023-09-14 08:58:22 时间
案例场景:
新建了一个表空间后TBS_MARKET_DAT,希望将归档的数据放置在这个表空间。
SQL CREATE TABLESPACE TBS_MARKET_DAT
2 DATAFILE /u04/oradata/gps/bookt_data_arch_01.dbf
3 SIZE 100M
4 AUTOEXTEND ON
5 NEXT 10M
6 MAXSIZE 4G
7 EXTENT MANAGEMENT LOCAL
8 SEGMENT SPACE MANAGEMENT AUTO ONLINE ;
用户A(默认表空间为TBS_ODS_DAT)创建表时指定表存储在表空间为TBS_MARKET_DAT时,遭遇ORA-01950: no privileges on tablespace TBS_MARKET_DAT
原因分析:
如下所示,用户没有权限在指定的表空间分配空间。只需要将表空间的权限授予给该用户即可。
[oracle@DB-Server ~]$ oerr ora 01950
01950, 00000, "no privileges on tablespace %s"
// *Cause: User does not have privileges to allocate an extent in the
// specified tablespace.
// *Action: Grant the user the appropriate system privileges or grant the user
// space resource on the tablespace.
解决方法:
方法1: 授予用户对该表空间的UNLIMITED配额
SQL ALTER USER ETL QUOTA UNLIMITED ON TBS_MARKET_DAT;
User altered.
SQL
方法2: 重新授权resource角色给用户之后,便可以创建表格
SQL GRANT RESOURCE TO ETL;
潇湘隐者 网名潇湘隐者/潇湘剑客、英文名Kerry,兴趣广泛,广泛涉猎,个性随意,不善言辞。执意做一名会写代码的DBA,混迹于IT行业
相关文章
- thrift.transport.TTransport.TTransportException: Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy mechs found
- No section matches selector - no section to be FIRST/LAST
- ERROR: Could not install packages due to an EnvironmentError: [Errno 28] No space left on device
- ORA-04089: cannot create triggers on objects owned by SYS
- [RxJS] Use finalize for side effects on completion
- [AWS DA GURU] KMS and Encryption on AWS
- mysql on DUPLICATE KEY UPDATE test1.name=test2.name;
- 3、ACE-实用生活口语---讲打电话Talking on the phone
- 【视频】vue指令v-on绑定事件
- No space left on device you must specify the filesystem type--Linux重启挂在失败
- /IWBEP/CX_MGW_TECH_EXCEPTION - expand issue for old service on Docu history node
- IOS No devices because active scheme has no targets
- NVIDIA之AI Course:Getting Started with AI on Jetson Nano—Class notes(四)
- 成功解决OSError: [Errno 28] No space left on device
- 成功解决ERROR: Could not install packages due to an EnvironmentError: [Errno 28] No space left on device
- 已解决SyntaxError: Non-UTF-8 code starting with ‘æ‘ in file E:/Python/3.py on line 4, but no encod
- 彻底地/ 终于地, 解决 关于apache 权限的问题了:: 修改 DocumentRoot后的 403错误: have no permission to access / on this server
- 论文解读(Survey)《Self-supervised Learning on Graphs: Contrastive, Generative,or Predictive》第二部分:对比学习
- 论文解读二代GCN《Convolutional Neural Networks on Graphs with Fast Localized Spectral Filtering》
- calico状态一直处于CrashLoopBackOff并且报错no valid IPv4 addresses found on the host interfaces
- DSR on Openstack POC
- PAT 1095 Cars on Campus
- Not enough free space on disks! linux
- redis的no-appendfsync-on-rewrite参数
- 虚拟机网卡重启报错:Error: No suitable device found: no device found for connection 'System eth0'
- ORA-01950: no privileges on tablespace 解决方案
- 成功解决ERROR: Could not install packages due to an EnvironmentError: [Errno 28] No space left on device
- Transformations on DStreams和Output Operations on DStreams