- 博客(9)
- 收藏
- 关注
转载 ORA-01659
ORA-01659 unable to allocate MINEXTENTS beyond string in tablespace string Cause: Failed to find sufficient con...
2008-11-01 23:09:23 158
转载 查询function/procedurce的privs
user_tab_privs/all_tab_privs本以为这个view只存放了table的授权,查询得到也包括了function/procedure的授权。[@more@] ...
2007-07-10 22:38:41 113
转载 移动table到指定的datafile
ALTER TABLE xx ALLOCATE EXTENT (size 200M datafile'other_ xxx.DBF');原文见:http://www.itpub.net/showthread.php?thread...
2007-06-13 07:44:08 117
转载 How to create a new table as original table with no data?
create table_b asselect * from table_a where 0 = 1; ps:all conditions whose result is false can be use here.[@more...
2007-06-09 17:14:30 216
转载 10g dbconsole无法启动时,对其进行重新配置即可
C:Documents and SettingsAdministrator>set oracle_sid=orclC:Documents and SettingsAdministrator>emctl start d...
2007-06-03 22:55:24 71
转载 关键时刻,感冒了~
昨天遇到的问题的,在add constraint中using index时用了PCTFREE 95,哈哈,是前阵子刚接触的这东西,所以刚好把PCTFREE跟PCTUSED记错了,结果是,建了个index用了10多G的空间。中间造...
2006-10-09 20:13:27 124
转载 关于ORA-12560: TNS:protocol adapter error得以解决
查了点资料,看了http://www.itpub.net/223688.html的文章,终于解决了。环境:两台Windows 2003 Svr Ent En sp1服务器,装都都是Oracle 9.2.0.7.0,两个服务器之间...
2006-08-27 14:03:20 722
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人