Oracle????????????????
???????????? ???????[ 2016/5/13 10:30:00 ] ????????????? SQL Server
???????Oracle????
????1??Oracle??????SQL Server???????
????SQL Server??????楗�???????????MDF??NDF????????????????????????????????????????“?????????????????”????????????????????????????????????????????????????????????????????些???????????????????????????????????????????濉�????????锟�???SQL Server?校???????????????械?????????PRIMARY???????? ??????????斜??????????????????????????????????????????????些????????????斜?????些????????????????????校?????????????????????????SQL Server ??????????????巍?
??????SQL Server???Oracle????械?????????Oracle??????????????????????睢�?????斜?????????????Oracle????????????Oracle????????????????????????????????????????????????????????SQL Server??????????Oracle?????Oracle????????SQL Server??????椤�????????????????Oracle?????
????2???????????????Oracle????
????Oracle?????????????????????????????????????????????????????????????????????????????????Oracle?写????????????????????DBA??????椋�?????????sys????????????????
????2.1???????????????TEMPFILE ???????卤???????????????????
????SIZE *[K??M]?????????小????位??????[K??M]
????MAXSIZE *[K??M]??????娲�???maxsize unlimited ?????????小?????????
????AUTOEXTEND ON NEXT *[K??M] ?????????????
????EXTENT MANAGEMENT LOCAL??????????
????extent??“????”?????????oracle??????校?extent management ???????? extent management local??????????; extent management dictionary??????????
?????????????local???????????????????(AUTOALLOCATE)??????小????(UNIFORM)????????????????????(AUTOALLOCATE)???????????????extents
??????小????????小????(UNIFORM)????????????extents??小????????????????????????效???uniform??????1M??小????temp???????????????????????
??????undo????.
--????
CREATE TEMPORARY TABLESPACE tsTempTest
TEMPFILE
'E:DataBasetsTempTest01.dbf' SIZE 64M AUTOEXTEND ON NEXT 32M MAXSIZE 1024M??
'E:DataBasetsTempTest02.dbf' SIZE 64M AUTOEXTEND ON NEXT 32M MAXSIZE 1024M??
'E:DataBasetsTempTest03.dbf' SIZE 64M AUTOEXTEND ON NEXT 32M MAXSIZE 1024M EXTENT MANAGEMENT LOCAL;
--????
ALTER TABLESPACE tsTempTest
ADD TEMPFILE
'E:DataBasetsTempTest04.DBF' SIZE 64M AUTOEXTEND ON NEXT 32M maxsize unlimited;
--???
DROP TABLESPACE tsTempTest INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
????2.2????????????????????????????????
--????
CREATE TABLESPACE tsUserTest
datafile
'E:DataBasetsUserTest01.dbf' size 64M AUTOEXTEND ON NEXT 32M maxsize unlimited ??
'E:DataBasetsUserTest02.dbf' size 64M AUTOEXTEND ON NEXT 32M maxsize unlimited ??
'E:DataBasetsUserTest03.dbf' size 64M AUTOEXTEND ON NEXT 32M maxsize unlimited extent management local ;
--????
ALTER TABLESPACE tsUserTest
ADD DATAFILE
'E:DataBasetsUserTest04.DBF' SIZE 64M AUTOEXTEND ON NEXT 32M maxsize unlimited;
--???
DROP TABLESPACE tsUserTest INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
????????Oracle???
????1???????????
?????????????????????????????????
????IDENTIFIED BY *** ???????????
????DEFAULT TABLESPACE *** ??????????
????TEMPORARY TABLESPACE *** ?????????
????CREATE USER xcj01 IDENTIFIED BY xcj01
????DEFAULT TABLESPACE tsUserTest
????TEMPORARY TABLESPACE tsTempTest;
????2?????????
????alter user xcj01
????identified by xcj01;
????3?????????????????????????
????drop user xcj01 CASCADE;
????????Oracle??????
????1??Oralce?????????
????1.1???????unlimited tablespace????????dba?? resource????械?????????. ????????dba??resource??????? unlimited tablespace?????????????????.
????1.2???????unlimited tablespace?????????role?? ????????????.
????1.3???????unlimited tablespace????????resource?? dba??????role??????????.
????2????????
????2.1??DBA????????????????????????
????2.2??CONNECT????? ??????????????????????????? ?????CREATE SESSION??
????2.3??RESOURCE??????????杩�??????? ????邪??????CREATE SEQUENCE??CREATE TRIGGER??CREATE CLUSTER??CREATE PROCEDURE??CREATE TYPE??CREATE OPERATOR??CREATE TABLE??CREATE INDEXTYPE??
????2.4??exp_full_database???????械????????????
????2.5??imp_full_database???????械????????????
??????

???路???
??????????????????
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