Archives

You are currently viewing archive for October 2008
Category: Oracle
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
Category: Linux tips
Posted by: hajime osako
Red Hat Configuration HOWTOs

# chkconfig --list ntpd
ntpd 0:off 1:off 2:off 3:off 4:off 5:off 6:off
# ntpdate -u ntp5.someserver.etc
9 Dec 15:15:15 ntpdate[12345]: step time server 123.123.123.123 offset 7.879896 sec
# chkconfig --level 345 ntpd on


# vi /etc/cron.daily/ntpdate.cron
------------------------
#!/bin/sh
/usr/sbin/ntpdate 210.173.160.27
------------------------

# chmod 755 /etc/cron.daily/ntpdate.cron
Category: Oracle
Posted by: hajime osako
DBAsupport.com : Oracle 10g Central : Oracle

Select username from dba_users;
SYS
OUTLN
QS_CBADM
PM
ANONYMOUS
SYSTEM
WMSYS
QS_OS
OE
WKSYS
DBSNMP
ORDSYS
QS_ES
RMAN
WKPROXY
SCOTT
ORDPLUGINS
QS_WS
QS_CS
ODM
SH
MDSYS
QS
QS_CB
ODM_MTR
HR
CTXSYS
QS_ADM
XDB
OLAPSYS
Category: Oracle
Posted by: hajime osako
Oracle(10g)のsqlplusについて質問です。 MySQLでいうshow databases/show tables/descコマンド(テーブル定義の表示)に相当する機能を教えてください。 sysdba???だったと.. - 人力検索はてな

$ sqlplus '/ as sysdba'
//show databases
select * From v$instance;

//show tables
select * From tab;

//descコマンド(テーブル定義の表示)
desc テーブル名

http://otn.oracle.co.jp/document/products/oracle10g/index.html
Category: Web dev
Posted by: hajime osako
Compiling PythonCode

import py_compile
py_compile.compile("mymodule.py")
Category: Web dev
Posted by: hajime osako
Category: Oracle
Posted by: hajime osako
6810189
Category: Web dev
Posted by: hajime osako
Thousands of Oracle & DB2 & SQL people answering each others questions

ALTER DATABASE KrediKartlari SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE KrediKartlari COLLATE Turkish_CI_AS
ALTER DATABASE KrediKartlari SET MULTI_USER
Category: MS tips
Posted by: hajime osako