当前位置:数据库 > Oracle >>

Oracle中获取表存放位置及创建表空间

Oracle中获取表存放位置及创建表空间
 
C:\Users\Administrator>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  www.zzzyk.com  
输入口令:
 
连接到:
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:\APP\ADMINISTRATOR\ORADATA\JXG1_20104350121\SYSTEM01.DBF
D:\APP\ADMINISTRATOR\ORADATA\JXG1_20104350121\SYSAUX01.DBF
D:\APP\ADMINISTRATOR\ORADATA\JXG1_20104350121\UNDOTBS01.DBF
D:\APP\ADMINISTRATOR\ORADATA\JXG1_20104350121\USERS01.DBF
D:\APP\ADMINISTRATOR\ORADATA\JXG1_20104350121\TABLE_LIZHENG.DBF
 
SQL> create tablespace Table_lizheng3 datafile 'D:\APP\ADMINISTRATOR\ORADATA\JXG1_20104350121\Table_lizheng3.DBF' size 100m autoextend on next 50m maxsize unlimited;
 
表空间已创建。
 
SQL>
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,