//创建表空间　　create tablespace MyFirstSpace datafile ‘/opt/oracle/app/oracle/product/9.2.0/dbs/MyFirstSpace.ora‘ size 512M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED default storage (initial 128K next 2M pctincrease 0); 　　　　sql>create tablespace fred 　　 datafile ‘d:\oracle\oradata\orcl\fred01.dbf‘ 　　 size 100K reuse;（reuse用于处理已经存在 datafiles）　　　　　　删除表空间命令：　　sql>drop tablespace INDX including contents;　　drop tablespace BLOBS including contents;　　drop tablespace BLOBS include contents and datafiles；（删除内容及datafiles）　　　　改变表空间大小命令：sql> ALTER database DATAFILE ‘INDX.dbf‘ resize 500M;　　　ALTER TABLESPACE spacename ADD DATAFILE ‘c:\orant\database\usr02.dbf‘ 　　 DEFAULT STORAGE (INITIAL 4M NEXT 2 M );