https://blog.youkuaiyun.com/Scofy0zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/Scofy0/article/details/50328329https://blog.youkuaiyun.com/Scofy0/article/details/50328329Scofy0Wed, 16 Dec 2015 15:27:21 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50326941https://blog.youkuaiyun.com/Scofy0/article/details/50326941Scofy0Wed, 16 Dec 2015 13:54:26 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50325877https://blog.youkuaiyun.com/Scofy0/article/details/50325877Scofy0Wed, 16 Dec 2015 11:58:01 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50325721https://blog.youkuaiyun.com/Scofy0/article/details/50325721Scofy0Wed, 16 Dec 2015 11:37:16 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50325579https://blog.youkuaiyun.com/Scofy0/article/details/50325579Scofy0Wed, 16 Dec 2015 11:30:22 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50320101https://blog.youkuaiyun.com/Scofy0/article/details/50320101Scofy0Tue, 15 Dec 2015 20:18:57 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50320039https://blog.youkuaiyun.com/Scofy0/article/details/50320039Scofy0Tue, 15 Dec 2015 20:12:31 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50316521https://blog.youkuaiyun.com/Scofy0/article/details/50316521Scofy0Tue, 15 Dec 2015 15:51:38 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50313887https://blog.youkuaiyun.com/Scofy0/article/details/50313887Scofy0Tue, 15 Dec 2015 12:40:10 +0800 show parameter sec_case_sensitive_logon  　　name type value  　　------------------------------------ ----------- ---------]]>https://blog.youkuaiyun.com/Scofy0/article/details/50250877https://blog.youkuaiyun.com/Scofy0/article/details/50250877Scofy0Thu, 10 Dec 2015 16:14:13 +0800 GRANT EXECUTE ON utl_file TO scofy; SQL> GRANT CREATE TABLE,CREATE SEQUENCE TO scofy; SQL> alter system set recyclebin=off scope=spfile; SQL> @marker_setup.sql Marker setup script ]]>https://blog.youkuaiyun.com/Scofy0/article/details/50247751https://blog.youkuaiyun.com/Scofy0/article/details/50247751Scofy0Thu, 10 Dec 2015 11:56:18 +0800 edit params defgen DEFSFILE ./dirdef/product.def userid scofy,password scofy table pdg.products;                      ////结构不同的表 ]]>https://blog.youkuaiyun.com/Scofy0/article/details/50240641https://blog.youkuaiyun.com/Scofy0/article/details/50240641Scofy0Wed, 09 Dec 2015 19:57:51 +0800 create user pdg identified by pdg; User created. SQL> grant dba to pdg; Grant succeeded. 2.创建表 SQL> conn pdg/pdg Connected. SQL> CREATE TABLE ]]>https://blog.youkuaiyun.com/Scofy0/article/details/50240407https://blog.youkuaiyun.com/Scofy0/article/details/50240407Scofy0Wed, 09 Dec 2015 19:49:07 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50234469https://blog.youkuaiyun.com/Scofy0/article/details/50234469Scofy0Wed, 09 Dec 2015 12:04:58 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50223601https://blog.youkuaiyun.com/Scofy0/article/details/50223601Scofy0Tue, 08 Dec 2015 20:24:24 +0800 use mysql; Reading table information for completion of table and column names You]]>https://blog.youkuaiyun.com/Scofy0/article/details/50211003https://blog.youkuaiyun.com/Scofy0/article/details/50211003Scofy0Mon, 07 Dec 2015 21:13:20 +0800https://blog.youkuaiyun.com/Scofy0/article/details/50210123https://blog.youkuaiyun.com/Scofy0/article/details/50210123Scofy0Mon, 07 Dec 2015 19:59:23 +0800 alter tablespace HZ_SOAR_INDEX_DATA add datafile '+DATADG/soarhz/datafile/hz_soar_index_data01.dbf' size  10g autoextend on maxsize 32G; alter tablespace HZ_SOAR_INDEX_DATA a]]>https://blog.youkuaiyun.com/Scofy0/article/details/49069217https://blog.youkuaiyun.com/Scofy0/article/details/49069217Scofy0Mon, 12 Oct 2015 09:15:43 +0800https://blog.youkuaiyun.com/Scofy0/article/details/48812197https://blog.youkuaiyun.com/Scofy0/article/details/48812197Scofy0Tue, 29 Sep 2015 21:51:34 +0800https://blog.youkuaiyun.com/Scofy0/article/details/48812081https://blog.youkuaiyun.com/Scofy0/article/details/48812081Scofy0Tue, 29 Sep 2015 21:48:44 +0800