????????
/*createtablespacesystemv
datafile'/opt/oracle/oradata/ibm/systemv01.dbf'size10m
autoextendon;*/
/*droptablespacesystemv
includingcontentsanddatafiles;*/
createuser"SYSTEMV"
identifiedby"123456"defaulttablespace"SYSTEMV"
accountunlock;
grantcreateanydirectory??unlimitedtablespace??connect??resourceto"SYSTEMV";
/*dropusersystemvcascade;*/
/*connectsystemv/123456@192.168.254.99/ibm*/
?????????
????????????????????????ж???
????drop user "aaaa" cascade
??????????????????????????????????????????????????????????????
????SQL> select * from v$dbfile;
????FILE#        NAME
????--------------------------------------------------------------------------------
????4                /mc/oracle/oradata/mc/users01.dbf
????--??????????????????????λ?????????????????????У?
????CREATE TABLESPACE AAAA
????DATAFILE '/mc/oracle/oradata/mc/AAAA.dbf' SIZE 50M
????extent management local autoallocate
????--??????????????????????????
????alter database
????DATAFILE '/mc/oracle/oradata/mc/AAAA.dbf'
????autoextend on
?????????????????????????????д??????sqlplus????????????????????????????????д???????????????Сд??????????
????$ sqlplus "aaaa/aaaa"??$ sqlplus "AAAA/aaaa" ??????????????????
?????????????????????????
????GRANT CREATE ANY DIRECTORY TO "AAAA"
????GRANT UNLIMITED TABLESPACE TO "AAAA"
????GRANT "CONNECT" TO "AAAA"
????GRANT "RESOURCE" TO "AAAA"
????????
????GRANT CREATE ANY DIRECTORY?? UNLIMITED TABLESPACE?? CONNECT?? RESOURCE TO "AAAA"