Oracle???????????
???????????? ???????[ 2014/4/15 16:00:33 ] ??????????????? ????? Oracle
????oracle??????????
????oracle ??????????????
??????1??????TABLESPACE?? ??????????????????α????????????????????????????????????????и??????????????????????????????
??????????????????????????磺 create table t(id int) tablespace tbs_test;
???????????????????
?????? ??????????
create tablespace TBS_LJB(??????)
datafile 'E:ORADATAORA11DATAFILETBS_LJB_01.DBF'(????????·??) size 100M????С??
extent management local --??????????oracle 10g??????汾???????????
segment space management auto;
|
?????????????
????CREATE TEMPORARY TABLESPACE temp_ljb
????TEMPFILE 'E:ORADATAORA11DATAFILETMP_LJB.DBF' SIZE 100M;
?????????α???
????create undo tablespace undotbs2
????datafile 'E:ORADATAORA11DATAFILEUNDOTBS2.DBF' size 100M;
????????
????1??????????????????????? tbs_ljb ????????? temp_ljb ??? ljb ?????????????
create user ljb
identified by ljb
default tablespace tbs_ljb
temporary tablespace temp_ljb;
-- ????ljb dba???
grant dba to ljb;
|
????2??????????????????????????
???????????????????????
????ALTER TABLESPACE TBS_LJB(??????) ADD DATAFILE '......'(????????·????) SIZE 100M;
????????????????????????????
????ALTER DATABASE DATAFILE '.......'(????????·????) autoextend on; (??????????????????????????????????????????)
????3?????????
????drop tablespace TBS_LJB
????including contents and datafile;
???????????????????????? including contents ????????????????? and datafiles ???????linux ?? unix ??????????????????????windows ???????????????
????4??UNDO ????? TEMP ????????????????????????????????????????????????????????????????????????
????5??oracle ?????????????????????????????????????????????session ???ò???????????????????飩?????????IO ??????
??????2???Σ?SEGMENT??
?????????????????????????Σ??????????????????????????????Ρ????????????????????????????????????Ρ?
??????3??????EXTENT??
????oracle ???????С??λ
??????4???饗BLOCK??
????oracle ??С????????λ
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11