オラクルユーザー作成プロセスの説明

sqlplus "sysman/password set during installation"  

パスワードで識別されるユーザーuserNameを作成します。

grant dba to userName; --grant DBA privileges  
grant unlimited tablespace to userName; --grant unlimited tablespace  
grant select any table to userName; --grant query any table  
grant select any dictionary to userName; --grant query any dictionary 

 
    CREATE TABLESPACE cheng DATAFILE 'C:\oraclexe\oradata\XE\cheng.dbf' SIZE 500M
UNIFORM SIZE 128k; #Specify the zone size as 128k,if not specified,the zone size defaults to 64k
 
--delete tablespace
 
     DROP TABLESPACE cheng INCLUDING CONTENTS AND DATAFILES
 
--modify tablespace size
 
     alter database datafile 'c:\oraclexe\oradata\XE\cheng.dbf' resize 50M