How to export and import dat from oracle server user expdp and impdp
摘要：create directory mydirectory as 'd:\data\dumpdir';select * from dba_directories;grant read,write on directory mydirectory to myusername;expdp myuserna
阅读全文
posted @
2012-07-31 11:36
子虚乌有
阅读(202)
推荐(0) 编辑
Software Configure
摘要：运行服务器的软件配置情况Function Name Version Port LicenseOperate System Suse or Redhat(Fedora Core) Stable is ok freeWebServer Apache 2.2.22 (2 above ) 80 free P
阅读全文
posted @
2012-07-19 14:26
子虚乌有
阅读(144)
推荐(0) 编辑
Learn Oracle CBO 1
摘要：Introduce去年select count 和 select data 留下的问题优化器如何选择最佳路径 ？ 如何计算代价 ？ 正文i/o 一般是大头 cpu 一般比较小 表内 full table scan = blocks = mbrc(multi-bolck read count) blo
阅读全文
posted @
2012-07-11 17:24
子虚乌有
阅读(147)
推荐(0) 编辑
OCI and ORA-12154
摘要：Today, we find a problem that ORA-12154: TNS:could not resolve the connect identifier specified. i think many people meet the problem. but today we fi
阅读全文
posted @
2012-07-04 16:35
子虚乌有
阅读(225)
推荐(0) 编辑
