개발관련/디비

관련 글 4
SQL Commands
개발관련/디비 2017. 9. 26. 17:22
# column not null ? ALTER TABLE distributors ALTER COLUMN street SET NOT NULL;ALTER TABLE distributors ALTER COLUMN street DROP NOT NULL;# primary key CREATE UNIQUE INDEX CONCURRENTLY dist_id_temp_idx ON distributors (dist_id); ALTER TABLE distributors DROP CONSTRAINT distributors_pkey, ADD CONSTRAINT distributors_pkey PRIMARY KEY USING INDEX dist_id_temp_idx;# CREATE function CREATE FUNCTION ch..
exp, imp
개발관련/디비 2017. 9. 19. 10:40
exp username/password@ exp userid=username/password file=c:\... drop user 계정이름 cascade; create user [username] identified by [password] default tablespace [tablespace_name] temporary tablespace temp; grant connect, dba, resource, EXP_FULL_DATABASE, IMP_FULL_DATABASE to [username]; 리눅스 su - 계정명 exp userid=username/password file=/home/... 재시작 su -l oracle lsnrctl stop sqlplus /nolog SQL > connect ..
PK생성,삭제
개발관련/디비 2017. 4. 19. 16:19
PK삭제 ALTER TABLE [table_name] DROP CONSTRAINT [pk_name] CASCADE; DROP INDEX [pk_name]; ALTER TABLE [table_name] DROP PRIMARY KEY; PK생성 ALTER TABLE [table_name] ADD CONSTRAINT [pk_name] PRIMARY KEY([컬럼1],[컬럼2],....);
Oracle Job
개발관련/디비 2017. 4. 12. 17:58
--job 수행 시간 및 간격, 실행 건수 확인 select schema_user db_user , what as job_proc , last_date , last_sec , next_date , next_sec , total_time pros_time , broken , interval , failures from dba_jobs order by schema_user, what ; --현재 진행중인 dbms job select j.sid, s.spid, s.serial#, j.log_user, j.job, j.broken, j.failures, j.last_date||':'||j.last_sec last_date, j.this_date||':'||j.this_sec this_date, j.next_da..

티스토리툴바