JavaNoob的博客

1, 建立连接 [code="java"] drop database link source_link; create database link source_link 　　 connect to user identified by password 　　 using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOC...

[code="c"] cat /proc/swaps | awk '{if(NR==2)print $3/1024"MB"}' [/code]

[code="java"] select * from dba_segments where owner='owner' AND segment_type='TABLE' and segment_name = 'table_name'; [/code]

select * from ( select * from your_table order by dbms_random.value ) where rownum

1 create or replace procedure p_test 2 as 3 v_G VARCHAR2(10); 4 begin 5 begin 6 select name into v_G from test where id =...

[code="java"] #!/bin/bash #define variable BASE_DIR=/home/user1/dbbak CURRENT_DATE=`date +%Y%m%d` DEST_DIR=dbbak-$CURRENT_DATE FULL_DEST_DIR=$BASE_DIR/$DEST_DIR ORACLE_BIN=/opt/oracle/product...

[code="java"] begin DBMS_SNAPSHOT.REFRESH('SNAPSHOT_NAME'); end; [/code]

[code="java"] 导出: exp username/password@database file=/var/bak/oracle.dmp 导入 imp username/password file=/var/bak/oracle.dmp full=y [/code]

假设有数据库db1和db2 , 表db1.t_task_msg, db2.t_task_msg 现在同步db1.t_task_msg数据到db2.t_task_msg 1, 在db2建立到db1的连接source_link [code="java"] create database link source_link 　　 connect to db1_user identified ...

安装过程中遇到不少问题，记录一下： wayne@wayne-laptop:~/.ssh$ ssh -X holly@10.8.66.201 holly@10.8.66.201′s password: Linux ubuntu108 2.6.24-19-server #1 SMP Wed Jun 18 14:44:47 UTC 2008 x86_64 The programs...