创建一个pagesize=8k的表空间出错： db2 =>; create regular tablespace ztest pagesize 8k managed by database using (file '/db2/sample/ztest.container000' 150) DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1582N The PAGESIZE of the table space "ZTEST" does not match the PAGESIZE of the buffer...
db2 =>; create tablespace USERSPACE1 managed by system using ('/db2/DEV') DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0298N Bad container path. SQLSTATE=428B2 请指教，谢谢。
I wonder if all my tablespace included system temporary tablespace and user temporary tablespace create under RAID then the value for EXTEND, PREFETCH, OVERHEAD, and TRANSFERRATE should having the same values no matter what page size it is? Please advise.
create table as select * from table1 tablespace tablespace1为啥tablespace tablespace1不对呀 该咋写?
创建表时有这样的错误的提示：unable to create INITIAL extent for segment in tablespace MYTAB，是不是表空间不够，怎么查看这个表空间的情况？
我想知道 为何一个数据文件会要 reuse呢？ 如果想重用，直接remove，然后creat tablespace 用同样的名称布就OK 因为数据反正都已经没有了 另外发下oracle 文档的牢骚，要找一个具体的reuse说明可真难啊 我是没有找到啊:em16:
DB2 8.1.6 AIX 5300-06 现象： 建实例、数据库、bufferpool正常完成； 建表空间失败（使用裸设备/dev/rlv*****01、02、03） create tablespace ****_8k pagesize 8k managed by database using (device '/dev/rlv*****01' 100000) bufferpool bf8k 提示：SQL0298N Bad container path. SQLSTATE=428B2 注：裸设备的属性、权限都检查过没问题，不知何故，请各位指教，在下多谢了！急呀！！！
创建表空间 create tablespace KInfoData datafile 'f:\KSSData\KInfoData01.ora' size 100M REUSE,'f:\KSSData\KInfoData02.ora' size 100M REUSE DEFAULT STORAGE(INITIAL 500K NEXT 500K PCTINCREASE 20); 想问其中的size 100M 是tablespace kInfoData 的空间大小吗,如果以后随着表的增多,100M可以改变吗,REUSE和PCTINCREASE 20是什么意思.
SQL>; create tablespace datas datafile '/opt/oracle/oradata/test/data01.dbf' size 512m reuse 2 autoextend on next 512k minimum extent 512k 3 default storage (initial 128k next 128k minextents 1 maxextents 4096 pctinc rease 0); create tablespace datas datafile '/opt/oracle/oradata/test/data01.dbf' size 512m reuse * ERROR at line 1: ORA-19502: write error on file "/opt/oracle/oradata/test/da...
