TD: Database.tables is being restored
来源:互联网 发布:顾客特殊要求矩阵 编辑:程序博客网 时间:2024/05/23 11:19
今天遇到一个问题,某个表一旦被access的话就会被锁住,报如下错误:
operation is not allowed;database.tables is being restored;
查看了dbcmangager里面也没有说现在正在restore这个表的用户存在,在arcmain中使用release lock (database) all 也没办法使用。
基于这个问题,在teradata forum上面找到了答案。
这个表可能以前restore的时候没有完成,只插入了结构和部分数据,然后abort了,需要使用build才能使其数据可用。方法如下:
登陆arcmain->build data tables (database.tablename);
- TD: Database.tables is being restored
- MS sqlserver数据库恢复出错 database is in use can not be restored
- database "mydb" is being accessed by other users
- 解决方法 dropdb: database removal failed: ERROR: database "TDADB" is being accessed by other users
- Cannot drop the database ‘XXX’ because it is being used for replication.
- PostgreSQL创建数据库时报错:ERROR: source database "template1" is being accessed by other users
- PostgreSQL创建数据库时报错:ERROR: source database "template1" is being accessed by other users
- Cannot drop the database XXX because it is being used for replication
- ORA-01155: the database is being opened, closed, mounted or dismounted
- hawq state 报错: the database is down, but Ambari shows all hawq services as being
- DoIt is Being Flooded
- tables in database
- 10 database tables
- SQL恢复备份遇到错误 - his differential backup cannot be restored because the database has not been restored
- [LeetCode][Database]Combine Two Tables
- 【Leetcode Database】Combine Two Tables
- 【leetcode】 database Combine Two Tables
- Database Leetcode Combine Two Tables
- java编程思想笔记--内部类部分四
- hdu 1983 Kaitou Kid - The Phantom Thief (2) (dfs+bfs+01三维判重 好题)
- java--map容器的hashcode和equals
- 困难的串问题
- UITableView学习笔记
- TD: Database.tables is being restored
- VisionMobile:2013年Q3移动开发者经济报告(十二):第十一章、了解开发者个性的复杂马赛克
- 利用shell脚本来监控linux系统的负载与CPU占用情况
- 游戏程序员养成计划
- c中结构体指针的强制类型转换
- husj oj
- Valid Sudoku
- sql模糊查询时遇到下划线的关键字问题
- 总是在离成功只有一丁点儿的距离的时候没有谨慎行事