Australia photo & PC memo

ArchWiki :: Subversion backup and restore - ArchWiki
svnadmin dump /path/to/reponame > /tmp/reponame.dump
svnadmin create /path/to/reponame
svnadmin load /path/to/reponame < /tmp/repo1.dump


Notes on installing cygwin subversion as a service on Windows 2003
Use cygrunsrv to install svnserve.exe as a service
I ran this from a cygwin shell window
cygrunsrv \
--install SvnServe \
--chdir D:\\SvnRepo \
--path C:\\cygwin\\lib\\subversion\\bin\\svnserve.exe \
--args "--foreground --daemon --root=/cygdrive/d/SvnRepo" \
--desc "Subversion for D:\\SvnRepo" \
--neverexits

iT-folder IT関連情報を配信
Oracle/PLSQL: Oracle System Tables

DBA_USERSの参照:
select USERNAME,ACCOUNT_STATUS from DBA_USERS;

SYSDBA/SYSOPER権限ユーザの確認:
select * from v$pwfile_users;

Check privileges by table name:
select * from dba_tab_privs where table_name = 'xxxxxx';

Checking the owner of table:
select owner, table_name from dba_tables where table_name = 'xxxxxxxx';

Search the column
select owner, table_name, column_name from dba_col_comments where column_name like '%xxxxx%'; (CAPITAL)

Checking the value of timed_statistics:
select value from v$parameter where name = ‘timed_statistics’;

Check SQL values:
SELECT
a.sql_text,
b.name,
b.position,
b.datatype_string,
b.value_string
FROM
v$sql_bind_capture b,
v$sqlarea a
WHERE
b.sql_id = a.sql_id