oracle 对表空间的基本操作

由于在plsql里面不能新建表空间，所以需要使用命令行来完成。

查询表空间的详细信息 select * from dba_data_files

SQL>  select * from dba_data_files;
 
FILE_NAME                                                                           FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS    RELATIVE_FNO AUTOEXTENSIBLE   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS
-------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- ----------- -------------
/u01/app/oradata/orcl/users01.dbf                                                         4 USERS                            11534336       1408 AVAILABLE            4 YES            3435972198    4194302          160   11468800        1400 ONLINE
/u01/app/oradata/orcl/undotbs01.dbf                                                       3 UNDOTBS1                        828375040     101120 AVAILABLE            3 YES            3435972198    4194302          640  828309504      101112 ONLINE
/u01/app/oradata/orcl/sysaux01.dbf                                                        2 SYSAUX                         1093992448     133544 AVAILABLE            2 YES            3435972198    4194302         1280 1093926912      133536 ONLINE
/u01/app/oradata/orcl/system01.dbf                                                        1 SYSTEM                          744488960      90880 AVAILABLE            1 YES            3435972198    4194302         1280  744423424       90872 SYSTEM
/u01/app/oradata/orcl/example01.dbf                                                       5 EXAMPLE                         104857600      12800 AVAILABLE            5 YES            3435972198    4194302           80  104792064       12792 ONLINE
/u01/app/oracle/dbs/C:ORACLEPRODUCT10.1.0ORADATAORCLTEST_DATA01.DBF                       6 TEST_DATA                        33554432       4096 AVAILABLE            6 YES            2147483648     262144         4096   33488896        4088 ONLINE
/u01/app/oradata/orcl/upay.dbf                                                            7 UPAY                            104857600      12800 AVAILABLE            7 YES            2147483648     262144         4096  104792064       12792 ONLINE
 
7 rows selected
 

创建表空间

Sql>create tablespace histdb datafile '/u01/app/oradata/orcl/upay.dbf' size 200m autoextend on next 10m maxsize unlimited;
Sql>alter database datafile '/u01/app/oradata/orcl/upay.dbf' autoextend on;

然后就是新建用户之类的操作了。