[收藏本方案]

手动建立 Oracle9i 数据库[68]

[入库：2005年8月18日] [更新：2007年3月24日]

本文简介：选择自 llmmysun 的 blog
首页 上页 下页 尾页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] [40] [41] [42] [43] [44] [45] [46] [47] [48] [49] [50] [51] [52] [53] [54] [55] [56] [57] [58] [59] [60] [61] [62] [63] [64] [65] [66] [67] [68] [69] [70] [71] [72] [73] [74] [75] [76]

上期专栏内容中我们曾经探讨过 oracle9i 的资料表空间规划方式。以步骤 5 的 create database 指令而言，新数据库内将只有一个 system 资料表空间。为了更有效地使用及管理 oracle9i 数据库，建议您另外新增数个资料表空间，依照应用系统实际需求而定。以下指令分别建立 users 与 indx 数据表空间。

 

create tablespace users logging

datafile '$oracle_home/oradata/mydb/users01.dbf '

size 25m reuse autoextend on next 1280k maxsize unlimited

extent management local;

 

create tablespace indx logging

datafile '$oracle_home/oradata/mydb/indx01.dbf '

size 25m reuse autoextend on next 1280k maxsize unlimited

extent management local;

 

 

首页 上页 下页 尾页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] [40] [41] [42] [43] [44] [45] [46] [47] [48] [49] [50] [51] [52] [53] [54] [55] [56] [57] [58] [59] [60] [61] [62] [63] [64] [65] [66] [67] [68] [69] [70] [71] [72] [73] [74] [75] [76]
本文关键：手动建立 Oracle9i 数据库
　　相关方案
Google
 

本站最佳浏览方式为 分辨率 1024x768 IE 6.0（或更高版本的 IE浏览器）

go top