netca , dbca
Connect as SYSTEM.
CREATE USER username IDENTIFIED BY apassword;
GRANT CONNECT TO username;
GRANT SELECT [, INSERT] [, UPDATE] [, DELETE] on schema.table TO username;
netca , dbca
Connect as SYSTEM.
CREATE USER username IDENTIFIED BY apassword;
GRANT CONNECT TO username;
GRANT SELECT [, INSERT] [, UPDATE] [, DELETE] on schema.table TO username;
Lazy 的 apache 有作這個設定
export NLS_NAME=”American_Taiwan.UTF8″
838 cd /proc/
840 ps auwwx|grep apache <– 找一個 apache 的 process id , ex: 21192
841 cd 21192
843 cat environ <– 把環境變數列出來
.
use exp
For example, in the following example, benefits table has a column called v_status. This exp command will export only the rows that contains “INVALID” as value in the v_status column.
$ exp hradmin/mypassword TABLES=benefits query=\"where v_status=\'INVALID\'\" .. About to export specified tables via Conventional Path ... . . exporting table BENEFITS 20783 rows exported
SQL*Loader (sqlldr) is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database.
hinet : 168.95.1.1 168.95.192.1
twnic : 192.83.166.11
seednet : 139.175.55.244
TFN : 211.78.215.137
Google : 8.8.8.8
cat /etc/syslog-ng.conf (省略) destination d_monster_syslog_server { udp( "192.168.1.123" port(514) ); file( "/var/log/logfile_$YEAR$MONTH$DAY.log" ); }; log { source(src); source(net); source(kernel); destination( d_monster_syslog_server ); };
cd /share/samba/solr-4.6.0/example
java -Dsolr.solr.home=multicore -jar start.jar