[카테고리:] 기술정보

Oracle Sybase %sqlplus system/manager SQL>create tablespace mpts/datafile ‘/data1/mpdb/mp.dbf’ size 100 default storage( initial 64K next 64K pctincrease 0 minextents 2 ); Tablespace create. SQL>create tablespace mptmpts/datafiile ‘/data1/mpdb/mp.dbf’ size 20M deault storage( initial 64K next 64K pctincrease 0 minextents 2 ); Tablespace create. SQL>create user medpack 2 indetified by medpack000 3 default tablesapce mpts 4 temporary …

Read more “Oracle과 Sybase 비교(create database)”

Oracle Sybase %su – oracle password: %svrmgrl SVRMGR>connect internal SVRMGR>shutdown SVRMGR>exit %lsnrctl stop %su – sybase password: %cd install %isql -Usa -P 1>shutdown SYB_BACKUP 2>go 1>shutdown

Oracle Sybase %su – oracle password: %svrmgrl SVRMGR>connect internal SVRMGR>startup SVRMGR>exit %lsnrctl start %su – sybase password: %cd install %startserver -f RUN_SYBASE %startserver -f RUN_SYS_BAKUP ※RUN_SYBASE, RUN_SYB_BACKUP는 Server name이므로 확인

SYBASE 사용법(요약) SYBASE home directory는 /home/sybase로 가정하며, 이하 ‘HOME’이라 합니다. 1.User System Account등록    1)User Account생성(System의 User등록방법에 따라)       Login as root – System Booting후 Root와 Password 입력)       Ex) #vi /etc/passwd/       Format] username:password:UID:GID:comment:user home directory:shell type       Example]sybase::100:100:SYBASE USER:/home/sybase:/bin/csh    2)User Directory생성       #cd /home       #mkdir sybase       #chown sybase sybase       #exit 2.Sysytem Login    Login as sybase – …

Read more “SYBASE 기본 사용법”