Article View: cn.bbs.comp.database
Article #8997Re: Oracle��ռ佨����ɺ�����ֶ���ôʵ�֣���
From: ����~! ����
Date: Mon, 15 Sep 2003 12:14
Date: Mon, 15 Sep 2003 12:14
27 lines
2317 bytes
2317 bytes
Ҳ�����ڴ���user��ʱ���ƶ�tablespace�����������user����Ͳ����ƶ���
eg: create user XXX identified by XXX default tablespace
USERDATA temporary tablespace temp;
conn XXX/XXX
create table test(name varchar2(255), class.....);
�� �� XOXOXOXO (Ϊʲô��) �Ĵ������ᵽ: ��
: CREATE TABLE "USER1"."TBL_1" (
: "ID" NUMBER(10) NOT NULL,
: "NAME" VARCHAR2(20) NOT NULL
: )
: TABLESPACE "DATA1"
: �������ΪTBL_1����ռ�ΪDATA1��
: �� �� handsomeboy (blueboy) �Ĵ������ᵽ: ��
: : oem�������ʵ�ִ������Table����
: : SQL plus�������Ҫ����һ��Table,��ô���ָ���ض���TableSpace?
: : ����˵�ҽ�һ��TableSpace����ΪTest,�봴��һ��Table(Col1,Col2...)
: .................������ʡ�ԣ�
--
�ӱ������ �Ӳ�ȥ������ �ٲ��˱���ûһ������
�������� ���ñ��� ���˵� ���˵� ������
Ҳ���� Ҳǣ�� Ҳ���ǰ취 ��Ҳ�� ��Ҳ�� ������
������ ���������� �ݺ�һ�������˰�
[m[1;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.242.141.59][m
Technical Details
Message-ID:
<48HS3d$bqb@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!cyclone.bc.net!logbridge.uoregon.edu!newsgate.cuhk.edu.hk!news.zixia.net!news.neu.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,82c3972cdc1d89fa X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-09-19 03:43:33 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!cyclone.bc.net!logbridge.uoregon.edu!newsgate.cuhk.edu.hk!news.zixia.net!news.neu.edu.cn!SJTU From: poorboy.bbs@bbs.sjtu.edu.cn (����~! ��У��) Newsgroups: cn.bbs.comp.database Subject: Re: Oracle��ռ佨����ɺ�����ֶ���ôʵ�֣��� Date: 15 Sep 2003 12:14:22 GMT Organization: ��ˮ˼Դ Message-ID: <48HS3d$bqb@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1063627959.A Lines: 27