![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
thedayyourejectme
这个作者很懒,什么都没留下…
展开
-
Install Oracle 10g and 11g in Windows XP SP2.
1 Firstly, I try to install oracle 11g in Windows XP SP2. Although I setup the loopback adaptor correctly in step #4, the em can’t be configured and started successfully. I tried the comman...2008-07-25 22:33:00 · 85 阅读 · 0 评论 -
Oracle Db Knowledge
See Attachment!2009-02-22 00:25:11 · 111 阅读 · 0 评论 -
Install Oracle Db in Windows XP
See attachment!2009-02-22 00:22:39 · 50 阅读 · 0 评论 -
PL/SQL三种集合类型的比较
PL/SQL三种集合类型的比较 集合是指在一个程序变量中包含多个值。PL/SQL提供的集合类型如下: Associative Array: TYPE t IS TABLE OF something INDEX BY PLS_INTEGER; Nested Table: TYPE t IS TABLE OF something; ...原创 2009-07-12 13:19:47 · 109 阅读 · 0 评论 -
View object source
Oracle select text from user_source DB2 select text from syscat.tables select text from syscat.procedures where procschema= and procname=2009-06-08 20:41:37 · 90 阅读 · 0 评论 -
Change the sequence
CREATE SEQUENCE DEMO.S_CUST_ID START WITH 2 MAXVALUE 10000000 MINVALUE 1 CYCLE NOCACHE NOORDER; ALTER SEQUENCE DEMO.S_CUST_ID INCREMENT BY 1 MINVALUE 1 ...2009-05-08 13:43:14 · 100 阅读 · 0 评论 -
impdp
impdb loads the dmp file from ORACLE_HOME/admin/ORACLE_SID/dpdump/test.dump, so before we run impdb, we put it into this folder. oracle@laptop-ubuntu:/opt/oracle/admin/orcl/dpdump$ impdp system/ma...2009-04-27 19:29:38 · 120 阅读 · 0 评论 -
spfile and pfile
spfile and pfile2009-04-20 13:15:14 · 79 阅读 · 0 评论 -
怎么控制oracle optimizer是用CBO还是RBO?
1. 第一个级别,spfile里的optimizer_mode 2. 第二个级别,alter session里的optimizer_goal alter session set optimizer_gole=ALL_ROWS 3. 第三个级别就是sql里的hint, CHOOSE, ALL_ROWS, FIRST_ROWS,RULE ...2008-09-24 13:06:51 · 239 阅读 · 0 评论 -
How to get the oracle server version?
select version FROM product_component_version where SUBSTR(PRODUCT,1,6)='Oracle';2008-08-26 17:41:28 · 72 阅读 · 0 评论 -
Oracle products and document
http://www.oracle.com/technology/documentation/index.html http://www.oracle.com/technology/products/index.html2008-08-02 16:14:39 · 52 阅读 · 0 评论 -
Install Oracle 11g in my Ubuntu Linux 8.
Installing Oracle 11g on Ubuntu Linux 8 I take this chapter from internet and install Oracle 11g in Ubuntu Linux 8. One little issue is that Ubuntu is unsupported by Oracle. So, through this text,...原创 2008-07-27 17:36:31 · 252 阅读 · 0 评论 -
Install Oracle 10g in Solaris 10
Steps 1. 修改内核 #vi /etc/system set shmsys:shminfo_shmmax=536870912 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:sem...2008-07-25 22:35:21 · 61 阅读 · 0 评论 -
Install Oracle XE in Debian
Steps Change the file /etc/apt/sources.list and add the following line to it. The line describes the repository position for debian from oracle. deb http://oss.oracle.com/debian un...2008-07-25 22:34:46 · 106 阅读 · 0 评论 -
Today, I found Oracle DB's username and password
Please see the cases. The account information are like these, username password SYS ADMIN SRDEMO ORACLE The results to try, command ...2008-07-25 22:34:00 · 60 阅读 · 0 评论 -
exp/imp
exp 将数据库内的各对象以二进制方式下载成dmp文件,方便数据迁移。 buffer:下载数据缓冲区,以字节为单位,缺省依赖操作系统 consistent:下载期间所涉及的数据保持read only,缺省为n direct:使用直通方式 ,缺省为n feeback:显示处理记录条数,缺省为0,即不显示 file:输出文件,缺省为expdat.dmp filesiz...原创 2009-02-25 00:17:03 · 547 阅读 · 0 评论