一些常用的 jar

http://www.360doc.com/content/12/0704/10/4280915_222166001.shtml

RHEL install Git

wget http://git-core.googlecode.com/files/git-1.8.1.3.tar.gz
tar xvsf git-*.gz  
yum install gcc
yum install zlib-devel
./configure
make
make install

vi ~/.wgetrc
.wgetrc 內容

    http_proxy = http://proxy.hinet.net:80/
    use_proxy = on
    wait = 15

JDBC url

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.144.82.137)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))

oracle expose from 11.2.0.1, import to 11.2.0.3

grant DBA to gsuser with admin option;
oracle 11.2.0.1
exp gsuser/gsuserpwd@orcl buffer=12800000 statistics=none consistent=y full=y file=./GS_342_INIT_TBS.dmp log=./exp_GS_342_INIT_TBS.log

oracle 11.2.0.3
imp gsuser/gsuserpwd@orcl buffer=12800000 statistics=none fromuser=gsuser touser=gsuser FULL IGNORE=y file=GS_342_INIT_TBS.dmp log=exp_GS_342_INIT_TBS.log

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@orcl ebao]$ echo $LANG
en_US.UTF-8
[oracle@orcl ebao]$ echo $NLS_LANG
AMERICAN_AMERICA.AL32UTF8
[oracle@orcl ebao]$

當有些table無法exp出來時, 該table可能是延遲建立 另外可以用下面的指令來避免table無法export的問題

select 'alter table '||table_name||' allocate extent;' from user_tables where SEGMENT_CREATED='NO';

打開/關閉 deferred segment creation

set deferred_segment_creation = [TRUE | FALSE]

Join的方法比較, inner join, left join, right join, outer join

準備資料

create table test1
(
 id number(1),
 name nvarchar2(10),
 phone nvarchar2(10)
);

create table test2
(
 id number(1),
 pid nvarchar2(10),
 country nvarchar2(10)
);


insert into test1 values(1, 'Mr.Wu', '0931123xxx');
insert into test1 values(2, 'Mr.Wang', '0932123xxx');
insert into test1 values(3, 'Mr.Lin', '0933123xxx');

insert into test2 values(1, '1', 'TW');
insert into test2 values(2, '1', 'US');
insert into test2 values(3, '2', 'Kaohsiung');
insert into test2 values(4, '3', 'Taipei');

Oracle系統環境有改時都要執行

exec dbms_stats.gather_system_stats('noworkload'); select * from sys.aux_stats$; exec dbms_stats.set_system_stats.. 可以設定 11g alter database backup controlfile to trace; -- trace select value from v$diag_info where name='Default Trace File'; -- 查詢 log file的位置 10g select spid from v$process where addr=(select paddr from v$session where sid = (select ...)); show parameter user_dump_dest;

Oracle 將 disable所有tables的constraint

先將 FK移除, 再移除其他的 constraint(如 primary key, null constraint等）

set pages 0
set echo off
spool 'c:\temp\disableConstranits.sql'
select 'Alter Table ' || table_name || ' disable constraint ' || constraint_name||';'  from DBA_constraints where constraint_type='R' and owner='DWUSER';
select 'Alter Table ' || table_name || ' disable constraint ' || constraint_name||';'  from DBA_constraints where constraint_type<>'R' and owner='DWUSER';
spool off

還原 constraint

set pages 0
set echo off
spool 'c:\temp\enableConstranits.sql'
select 'Alter Table ' || table_name || ' enable constraint ' || constraint_name||';'  from DBA_constraints where constraint_type<>'R' and owner='DWUSER';
select 'Alter Table ' || table_name || ' enable constraint ' || constraint_name||';'  from DBA_constraints where constraint_type='R' and owner='DWUSER';
spool off

查看執行的 processes

select * from V$PROCESS;