数据库相关 - 随笔分类(第2页) - 子虚乌有

How to create table on another schema ?

摘要：How to create table on another schema ? Question: we want to create table on anothere schema use different user; just like user a create table in user b. create user a identified by "pass" password... 阅读全文

posted @ 2013-09-23 15:56 子虚乌有阅读(327) 评论(0) 推荐(1)

How to start XE by command

摘要：start xe by command (sqlplus) in my environment windows7 xe 10.2.0.1.0 Since there are Oracle 11 on my machine, so i use set command to set temp variable 1. Start lsnrctl.exe set ORACLE_SID=X... 阅读全文

posted @ 2013-08-12 13:14 子虚乌有阅读(322) 评论(0) 推荐(0)

How to use spool example

摘要：----------main.sql--------------------- spool main.log prompt --start main--; prompt ==============; prompt prompt ***start sub1.sql***; @@sub1.sql spool main.log append prompt ***end sub1.sql***; ... 阅读全文

posted @ 2013-04-11 15:38 子虚乌有阅读(152) 评论(0) 推荐(0)

Learn PL/SQL 1. How to use array(temp array)

摘要：Learn PL/SQL 1. How to use array(temp array) create table test_caseid (caseid RAW(16), userid NUMBER(9,0), activeflag NUMBER(9,0) DEFAULT 0); declare type array_t is varray(13) of NUMBER; --temp... 阅读全文

posted @ 2013-03-25 14:05 子虚乌有阅读(191) 评论(0) 推荐(0)

oracle event 'disk file operations i/o'

摘要：Disk file operations I/O This event is used to wait for disk file operations (for example, open, close, seek, and resize). It is also used for miscell 阅读全文

posted @ 2013-03-22 16:33 子虚乌有阅读(2642) 评论(0) 推荐(0)

Sybase ODBC parameters

摘要：When we use ODBC connect Sybase DataBase, if there is some null values.we need set ansinull to 0. For ODBC connection, there exists connection.command 阅读全文

posted @ 2012-08-30 09:39 子虚乌有阅读(137) 评论(0) 推荐(0)

Access miss typematch and Sybase password

摘要：Access type misssmatch error join on different typessuch as tbl_1 LEFT JOIN tbl_2 AS counter ON tbl_1.nameID = counter.compIDSybase set password probl 阅读全文

posted @ 2012-08-10 09:44 子虚乌有阅读(152) 评论(0) 推荐(0)

ora-01691 error no space

摘要：Today, When i come to company,check the result what i run yesterday. but there some error. as follow:ORA-01691 unable to extend lob segment string.str 阅读全文

posted @ 2012-08-02 13:16 子虚乌有阅读(244) 评论(0) 推荐(0)

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 子虚乌有阅读(206) 评论(0) 推荐(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 子虚乌有阅读(151) 评论(0) 推荐(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 子虚乌有阅读(230) 评论(0) 推荐(0)

for drop user username cascade

摘要：In some case, we may want to drop user.so we can use this sql as follow: drop user username cascade; but if the user is connected, we can't drop it.so 阅读全文

posted @ 2012-06-29 17:04 子虚乌有阅读(230) 评论(0) 推荐(0)

Drop user cascade and start sql server browser

摘要：select 'drop user "' || username || '" cascade; ' from dba_users WHERE username like 'name%'; sql server browser must start, if you want use remote sq 阅读全文

posted @ 2012-06-29 11:17 子虚乌有阅读(220) 评论(0) 推荐(0)

Enviroment for Oracle_home& Path

摘要：About oracle XE and client for oracle In my environment, there is client for oracle exists, so after i install oracle XE, there may problem happen.aft 阅读全文

posted @ 2012-06-28 17:02 子虚乌有阅读(328) 评论(0) 推荐(0)

select syntax and ORA-01797

摘要：select count(*) from (select * from ( select * from TestLoad.dbo.T_TestType where mid = 42) main_query)only supported Oracle, Sql server and Sybase(AS 阅读全文

posted @ 2012-06-21 17:11 子虚乌有阅读(1246) 评论(0) 推荐(0)

Some configure

摘要：set oralcexe sa passwordorapwd file=PWDXE.ora password=iris entries=10 install sql 2008 ee version, need pwer shell in win2008 sp2down load power shel 阅读全文

posted @ 2012-05-23 14:22 子虚乌有阅读(283) 评论(0) 推荐(0)

For Sybase

摘要：For Sybase1.Down Load Address ; http://www.sybase.com/detail?id=1051287&elq=00000000000000000000000000000000ase157_winx64.zip 2.install and create Dat 阅读全文

posted @ 2012-05-22 15:03 子虚乌有阅读(467) 评论(0) 推荐(0)

ora optimizer

摘要：Alter system set optimizer_features_enable='10.2.0.1'; Alter system set optimizer_features_enable='11.2.0.2'; 阅读全文

posted @ 2012-03-12 17:06 子虚乌有阅读(179) 评论(0) 推荐(0)

drop user in oracle

摘要：drop user eurekaperf cascade; select username,sid,serial# from v$session; alter system kill session 'sid,serial#'; when you want to drop a schema. now 阅读全文

posted @ 2011-12-22 17:42 子虚乌有阅读(170) 评论(0) 推荐(0)

About oracle path for configure file

摘要：first,tnsping dev02, test configure in tnsnames.ora file,it's oksecodsqlplus username/password@dev02, is also work but when i start the program, it re 阅读全文

posted @ 2011-11-29 16:15 子虚乌有阅读(297) 评论(0) 推荐(0)

随笔分类 - 数据库相关