create table bb
partition by range (date)
(partition part1 values less than ('20040705') tablespace DATA_01,
partition part2 values less than ('20040709') tablespace DATA_02,
partition part3 values less than ('20040713') tablespace DATA_03,
partition part4 values less than ('20040717') tablespace DATA_04,
partition part5 values less than ('20040721') tablespace DATA_05,
partition part6 values less than ('20040725') tablespace DATA_06,
partition part7 values less than ('20040729') tablespace DATA_07,
partition part8 values less than (MAXVALUE) tablespace DATA_08);
as select * from aa@data1
partition by range (date)
(partition part1 values less than ('20040705') tablespace DATA_01,
partition part2 values less than ('20040709') tablespace DATA_02,
partition part3 values less than ('20040713') tablespace DATA_03,
partition part4 values less than ('20040717') tablespace DATA_04,
partition part5 values less than ('20040721') tablespace DATA_05,
partition part6 values less than ('20040725') tablespace DATA_06,
partition part7 values less than ('20040729') tablespace DATA_07,
partition part8 values less than (MAXVALUE) tablespace DATA_08);
as select * from aa@data1
ERROR 位于第 3 行:
ORA-00959: 表空间'DATA_01'不存在
我加上物理路径,或者后缀.dbf
他就提示
ERROR 位于第 3 行:
ORA-14020: 不可以指定表分区的此物理属性
但我的表空间的数据文件确实是
H:\CDRDATA\DATA_01.DBF
就是这样的,请指教!
建立表空间先。CREATE TABLESPACE DATA_01
DATAFILE 'H:\CDRDATA\DATA_01.DBF' SIZE 100M REUSE;别忘记把其它表空间都建了......
执行以下脚本:CREATE TABLESPACE DATA_01
DATAFILE 'H:\CDRDATA\DATA_01.DBF' SIZE 100M REUSE;
CREATE TABLESPACE DATA_02
DATAFILE 'H:\CDRDATA\DATA_02.DBF' SIZE 100M REUSE;
CREATE TABLESPACE DATA_03
DATAFILE 'H:\CDRDATA\DATA_03.DBF' SIZE 100M REUSE;
CREATE TABLESPACE DATA_04
DATAFILE 'H:\CDRDATA\DATA_04.DBF' SIZE 100M REUSE;
CREATE TABLESPACE DATA_05
DATAFILE 'H:\CDRDATA\DATA_05.DBF' SIZE 100M REUSE;
CREATE TABLESPACE DATA_06
DATAFILE 'H:\CDRDATA\DATA_06.DBF' SIZE 100M REUSE;
CREATE TABLESPACE DATA_07
DATAFILE 'H:\CDRDATA\DATA_07.DBF' SIZE 100M REUSE;
CREATE TABLESPACE DATA_08
DATAFILE 'H:\CDRDATA\DATA_08.DBF' SIZE 100M REUSE;create table bb
partition by range (date)
(partition part1 values less than ('20040705') tablespace DATA_01,
partition part2 values less than ('20040709') tablespace DATA_02,
partition part3 values less than ('20040713') tablespace DATA_03,
partition part4 values less than ('20040717') tablespace DATA_04,
partition part5 values less than ('20040721') tablespace DATA_05,
partition part6 values less than ('20040725') tablespace DATA_06,
partition part7 values less than ('20040729') tablespace DATA_07,
partition part8 values less than (MAXVALUE) tablespace DATA_08)
as select * from aa@data1;要是还有报错,再把完整报错信息发上来
From User_Segments Where segment_name='BB'
Group By segment_name,partition_name,Tablespace_name