Test resource is busy or not for ORACLE
摘要：Some time, we have no system or dba role, we must use schema ownere to test the resource busy or not follow is the test: // start sqlplus1 drop table
阅读全文
posted @
2013-11-19 10:11
子虚乌有
阅读(216)
推荐(0) 编辑
Execute CMD in the C# program
摘要：public static bool TestComand(string command, ref string outmessage) { string mypath = System.AppDomain.CurrentDomain.BaseDirectory; string parameter = " -help"; ...
阅读全文
posted @
2013-11-12 19:33
子虚乌有
阅读(345)
推荐(0) 编辑
LogicalSchema sql script
摘要：-------------------------------------------------------------------------------- -- logicalschema.sql -- 1. Set initial preferences for the logicalschema instance -- 2.Install clean-up procedure for...
阅读全文
posted @
2013-11-12 19:27
子虚乌有
阅读(207)
推荐(0) 编辑
The problem when we use IMPDP
摘要：create directory mydir as 'c:\data' grant read,write on directory mydir to schemaname; export: expdp user/pass@db DIRECTORY=mydirectory schemas=schema
阅读全文
posted @
2013-11-12 19:19
子虚乌有
阅读(179)
推荐(0) 编辑
