C:UsersAdministrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on 星期五 3月 1 17:16:09 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
请输入用户名: sys
输入口令:
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
D:APPADMINISTRATORORADATAJXG1_20104350121SYSTEM01.DBF
D:APPADMINISTRATORORADATAJXG1_20104350121SYSAUX01.DBF
D:APPADMINISTRATORORADATAJXG1_20104350121UNDOTBS01.DBF
D:APPADMINISTRATORORADATAJXG1_20104350121USERS01.DBF
D:APPADMINISTRATORORADATAJXG1_20104350121TABLE_LIZHENG.DBF
SQL> create tablespace Table_lizheng3 datafile 'D:APPADMINISTRATORORADATAJXG1_20104350121Table_lizheng3.DBF' size 100m autoextend on next 50m maxsize unlimited;
表空间已创建。
SQL>