when create a table,then show error ora-00952 tablespace tsb_1 not exist
2024-10-16 16:51:28
QUESTION:When create a table,then show error ora-00952 tablespace tsb_1 not exist.
STEP:
1.select user table tablespace.
SELECT username,DEFAULT_TABLESPACE,temporary_tablespace FROM dba_users WHERE username='LJB';
2.select user owner tablespace.
SELECT * FROM User_Tablespaces;
3.alter user default tablespace.
ALTER USER ljb DEFAULT TABLESPACE USERS;
4.checking tablespace
SELECT username,DEFAULT_TABLESPACE,temporary_tablespace FROM dba_users WHERE username='LJB';
最新文章
- Vertica DBD 分析优化设计
- java.net.SocketException: recvfrom failed: ECONNRESET (Connection reset by peer)可能出现的原因
- JAVA 线程中的异常捕获
- API测试
- cookie的实例
- DevStack安装时报“download of get-pip.py failed”
- innobackupex使用实践
- 使用SharePoint Designer定制开发专家库系统实例!
- [ActionScript 3.0] AS3 3D双圆环贴图
- 【Qt】Qt Creator快捷键【转】
- zoj 1649 Rescue (BFS)(转载)
- 【USACO 2.4.2】穿越栅栏
- POJ1273(最大流)
- Example013操作样式
- Java开源生鲜电商平台-安全设计与架构(源码可下载)
- [Swift]LeetCode717. 1比特与2比特字符 | 1-bit and 2-bit Characters
- for循环输出树木的形状【java】
- Java 作业6
- 神州数码广域网PPP封装PAP认证配置
- Oracle数据库备份还原工具之Expdp/IMPdp
热门文章
- codeforces 1101F Trucks and Cities 区间dp+单调优化 好题
- Cannot reinitialise DataTable 问题
- 116th LeetCode Weekly Contest Maximum Width Ramp
- Counting Divisors HDU - 6069
- 【总结】ettercap工具之arp欺骗
- Scrapy安装指南(windows)
- Vue.js插槽slot和作用域插槽slot-scope学习小结
- <;th>;折行显示
- vue组件(持续更新)
- 《The Python Standard Library》——http模块阅读笔记1