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