本文主要验证lvm+raw设备 表空间的最大可用空间大小 --1.建表空间之前的准备,/dev/raw/raw14大小为8m [oracle@master ~]$ ln -s
本文主要验证lvm+raw设备 表空间的最大可用空间大小
--1.建表空间之前的准备,/dev/raw/raw14大小为8m
[oracle@master ~]$ ln -s /dev/raw/raw14 /oracle/oradata/rawt/test01.dbf
--2.创建表空间
sql> create tablespace test
datafile '/oracle/oradata/rawt/test01.dbf' size 2m
autoextend on;
--3.查看文件大小，并插入数据直到空间不足
sql> select bytes/1024/1024,maxbytes/1024/1024 from dba_data_files where file_id=5;
bytes/1024/1024 maxbytes/1024/1024
--------------- ------------------
2 32767.9844 --创建表空间时，没有指定最大值，，这个地方为约32g
sql>
sql>
sql>
sql>
sql> select count(*) from dba_objects;
count(*)
----------
50032
sql> create table t (id int,name varchar2(20)) tablespace test;
table created.
sql> insert into t select rownum,'1111111111' from dba_objects where rownum
49999 rows created.
sql> commit;
commit complete.
sql> insert into t select rownum,'1111111111' from dba_objects where rownum
49999 rows created.
sql> commit;
commit complete.
sql> insert into t select rownum,'1111111111' from dba_objects where rownum
49999 rows created.
sql> insert into t select rownum,'1111111111' from dba_objects where rownum
49999 rows created.
sql> insert into t select rownum,'1111111111' from dba_objects where rownum
49999 rows created.
sql> insert into t select rownum,'1111111111' from dba_objects where rownuminsert into t select rownum,'1111111111' from dba_objects where rownum*
error at line 1:
ora-01653: unable to extend table sys.t by 128 in tablespace test
sql> commit;
commit complete.