1 min to read

귀찮아서 적어놈

oracle sql

Featured image

생각날때 마다 갱신할 예정

ALTER SYSTEM kill SESSION (80, 1108517);

ALTER TABLESPACE TEMP ADD TEMPFILE ‘C:\TmaxData\tibero6\database\tibero\temp_002.dbf’ size 10240M;

alter database datafile ‘C:\TmaxData\tibero6\database\tibero\undo_001.dbf’ resize 10000M;

ALTER INDEX 인덱스명 RENAME TO 바꿀인덱스;

CREATE TABLESPACE TS_S DATAFILE ‘D:\TMAXDATA\TIBERO\TS_S.DBF’ SIZE 1000M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;

CREATE TABLESPACE TS_IDX_S DATAFILE ‘D:\TMAXDATA\TIBERO\TS_IDX_S.DBF’ SIZE 1000M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;

URIEncoding=”UTF-8”