发布时间:2014-12-05 18:10:52
create user kimi identified by kimi1234 default tablespace data;grant resource,connect to kimi;ORA-00439: feature not enabled: Partitioning select * from v$option where parameter = 'Partitioning';PARAMETER VALUE-------------------------------------.........【阅读全文】
发布时间:2014-11-25 21:38:05
--监控ASM使用率SELECT name group_name , sector_size sector_size , block_size block_size , allocation_unit_size allocation_unit_size , state state , type type , total_mb total_mb , (total_mb - free_mb) u.........【阅读全文】
发布时间:2014-09-15 16:22:41
db2 connect SQL30082N failed with reason 24db2 grant connect on database to user LXCHARTdb2 "select * from syscat.dbauth where grantee='LXCHART'"### 授予权限后还是报同样的错误[hostname:/db2home/db2inst2/sqllib/db2dump] # [hostname:/db2home/db2inst2/sqllib/db2dump] # db2 connect to XCHRT user&.........【阅读全文】
发布时间:2014-09-14 12:49:50
问题描述 :db2level : DB2 v9.7.0.9OS : aix 7.1目的是要测试 cross-platform migration ( from AIX to Linux), 然后在使用 db2move export 导出全库表时,虽没有报错,但是出现很多警告(EXPORT.out) 。 全库大约 700 多张表 ,但在db2move.lst文件上却只有几条记录。db2inst1@hostname:/home/db2inst1# db2.........【阅读全文】
发布时间:2014-08-22 01:59:02
$ db2 connect to dbname Database Connection Information Database server = DB2/AIX64 9.7.6 SQL authorization ID = UAWEB Local database alias = UAWEBSCH$ db2 terminateDB20000I The TERMINATE comm.........【阅读全文】