Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CREATE TABLESPACE AND ORA-03214

LonionMar 27 2012 — edited Mar 27 2012

when i create tablespace specifiled size less than 81,it occurs an error :ora-03214,the following code

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 64K;
CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 64K
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required


SQL> CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 65K;
CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 65K
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required


SQL> CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 79K;
CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 79K
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required


SQL> CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 80K;
CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 80K
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required


SQL> CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/lonion/TEST01.dbf' SIZE 81K;

Tablespace created.

SQL> SELECT TABLESPACE_NAME,BLOCK_SIZE ,INITIAL_EXTENT FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = 'TEST';

TABLESPACE_NAME            　　 BLOCK_SIZE    　   INITIAL_EXTENT
--------------------        -------------------　　    --------------
TEST                           8192             　    65536

why the size is 81 can create tablespace successfully? how to calculate it?

This post has been answered by sb92075 on Mar 27 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2012

Added on Mar 27 2012

#general-database-discussions, #oracle

5 comments

10,515 views