本帖最后由 pl_mm5 于 2012-07-06 09:39:36 编辑
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
|
prompt Creating DM_2...
create
table
DM_2
(
CD_DM VARCHAR2(10)
not
null
,
CD_MC VARCHAR2(30),
CD_URL VARCHAR2(100)
)
tablespace USERS pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter
table
DM_2
add
constraint
CDD
primary
key
(CD_DM)
using
index
tablespace TS_JSI2_JQZH pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
|
这是看到的一个建表脚本,有几个问题不明白
1、Oracle建议要把一个用户的数据分离到多个表空间。为什么?
2、这里建表为什么还要指定表空间,一般不是在新建的用户下,create 表么,创建用户时候指定一个表空间,为什么要这么设计?
3、一个用户有一个默认表空间,那这个用户怎么使用多个表空间下的表数据?
========
以下为csdn广告。。。。。。。。。。
-
id="iframeu1636200_0" src="http://pos.baidu.com/fcxm?rdid=1636200&dc=2&di=u1636200&dri=0&dis=0&dai=2&ps=1535x191&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1463627522396&ti=oracle%E5%88%9B%E5%BB%BA%E8%A1%A8%E6%97%B6%E5%80%99%E6%8C%87%E5%AE%9A%E8%A1%A8%E7%A9%BA%E9%97%B4%EF%BC%9F-CSDN%E8%AE%BA%E5%9D%9B-CSDN.NET-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF%E7%A4%BE%E5%8C%BA&ari=1&dbv=2&drs=3&pcs=904x514&pss=960x5540&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1463627522<u=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390123451<r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DM3wB2PKQ3Nm-mb9ZS4L6CfwmHSJHeh2ITOmlRwMqzJATCK7we9K56yA1pucuJT8s%26wd%3D%26eqid%3De08715170002fa5a00000005573d2eaf&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1463627522&qn=007a501a7610a2d2&tt=1463627522368.33.287.289" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
-
id="iframeu1636201_0" src="http://pos.baidu.com/fcxm?rdid=1636201&dc=2&di=u1636201&dri=0&dis=0&dai=3&ps=1535x445&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1463627522396&ti=oracle%E5%88%9B%E5%BB%BA%E8%A1%A8%E6%97%B6%E5%80%99%E6%8C%87%E5%AE%9A%E8%A1%A8%E7%A9%BA%E9%97%B4%EF%BC%9F-CSDN%E8%AE%BA%E5%9D%9B-CSDN.NET-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF%E7%A4%BE%E5%8C%BA&ari=1&dbv=2&drs=3&pcs=904x514&pss=960x5540&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1463627522<u=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390123451<r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DM3wB2PKQ3Nm-mb9ZS4L6CfwmHSJHeh2ITOmlRwMqzJATCK7we9K56yA1pucuJT8s%26wd%3D%26eqid%3De08715170002fa5a00000005573d2eaf&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1463627522&qn=389977260ddc57eb&tt=1463627522368.35.292.295" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
-
id="iframeu1636204_0" src="http://pos.baidu.com/fcxm?rdid=1636204&dc=2&di=u1636204&dri=0&dis=0&dai=4&ps=1535x699&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1463627522396&ti=oracle%E5%88%9B%E5%BB%BA%E8%A1%A8%E6%97%B6%E5%80%99%E6%8C%87%E5%AE%9A%E8%A1%A8%E7%A9%BA%E9%97%B4%EF%BC%9F-CSDN%E8%AE%BA%E5%9D%9B-CSDN.NET-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF%E7%A4%BE%E5%8C%BA&ari=1&dbv=2&drs=3&pcs=904x514&pss=960x5540&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1463627522<u=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390123451<r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DM3wB2PKQ3Nm-mb9ZS4L6CfwmHSJHeh2ITOmlRwMqzJATCK7we9K56yA1pucuJT8s%26wd%3D%26eqid%3De08715170002fa5a00000005573d2eaf&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1463627522&qn=853110bbe46c9733&tt=1463627522368.37.297.299" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">