10/30: Oracle > column format
10/22: Linux > ntp ntpd
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
# 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
10/17: Oracle > default users
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
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
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
$ 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
10/15: Python > Compiling
10/15: python > decompiler
10/13: Oracle > 10.2.0.4
6810189
10/07: MSSQL > Change collation
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
ALTER DATABASE KrediKartlari SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE KrediKartlari COLLATE Turkish_CI_AS
ALTER DATABASE KrediKartlari SET MULTI_USER