Obtain the table storage location and create a tablespace in Oracle

Oracle obtains the table storage location and creates the tablespace C: \ Users \ Administrator> sqlplus SQL * Plus: Release 11.2.0.1.0 Production on Friday March 1 17:16:09 2013 Copyright (c) 1982,201 0, Oracle. all rights reserved. enter the User name: sys www.2cto.com and enter the password: connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionWith the Partitioning, OLAP, data Mining and Real Application Testing options SQL> select name from v $ datafile; NAME ------- Mongod: \ APP \ ADMINISTRATOR \ ORADATA \ jxg000020104350121 \ SYSTEM01.DBFD: \ APP \ ADMINISTRATOR \ ORADATA \ platform \ SYSAUX01.DBFD: \ APP \ ADMINISTRATOR \ ORADATA \ jxg000020104350121 \ login: \ APP \ ADMINISTRATOR \ ORADATA \ jxg000020104350121 \ USERS01.DBFD: \ APP \ ADMINISTRATOR \ ORADATA \ jxg000020104350121 \ TABLE_LIZHENG.DBF SQL> create tablespace Table_li Zheng3 datafile 'd: \ APP \ ADMINISTRATOR \ ORADATA \ jxg000020104350121 \ Table_lizheng3.DBF 'size 100 m autoextend on next 50 m maxsize unlimited; tablespace created. SQL>