-
编辑 删除
查询function/procedurce的privs
user_tab_privs/all_tab_privs本以为这个view只存放了table的授权，查询得到也包括了function/procedure的授权。[@more@]
-
编辑 删除
移动table到指定的datafile
ALTER TABLE xx ALLOCATE EXTENT (size 200M datafile'other_ xxx.DBF');原文见:http://www.itpub.net/showthread.php?threadid=789239[@more@]
-
编辑 删除
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@]
-
编辑 删除
10g dbconsole无法启动时，对其进行重新配置即可
C:Documents and SettingsAdministrator>set oracle_sid=orclC:Documents and SettingsAdministrator>emctl start dbconsoleUnable to determine local host from URL REPOSITORY_URL=http://ora10g-pc:%EM_UPLOAD_PORT%/em/upload/.C:Documents and SettingsAdministrator>emca -config dbcontrol dbEMCA 开始于 2007-6-3 22:50:34EM Configuration Assistant 10.2.0.1.0 正式版版权所有 (c) 2003, 2005, Oracle。保留所有权利。输入以下信息:数据库 SID: orcl已为数据库 orcl 配置了 Database Control您已选择配置 Database Co
-
编辑 删除
表的依赖关系信息
public_dependencyall_dependenciesuser_dependencies[@more@]
