Solved

create tablespace

Posted on 2011-03-09
5
983 Views
Last Modified: 2012-05-11
When I am executing:
SQL> create tablespace appl datafile
'/abc/test/oracle/dbname/abc01.dbf' size 2 GB
LOGGING ONLINE PERMANENT BLOCKSIZE 32768 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;


Create tablespace appl datafile
ERROR at line 1:
ORA-29339: tablespace block size 32768 does not match configured block sizes
0
Comment
Question by:hussainkhan22
  • 3
5 Comments
 
LVL 6

Assisted Solution

by:anumoses
anumoses earned 160 total points
ID: 35082495
0
 
LVL 6

Expert Comment

by:anumoses
ID: 35082501
Is it for 11G?
0
 
LVL 68

Assisted Solution

by:woolmilkporc
woolmilkporc earned 160 total points
ID: 35082535
Hi,

the problem is obviously that you didn't create an individual buffer cache.
Such a buffer cache must be defined for each non-standard block size used!

ALTER SYSTEM SET DB_32K_CACHE_SIZE=16M SCOPE=SPFILE;
(or some other convenient size instead of 16M).
SHUTDOWN and STARTUP
Create tablespace ...

wmp
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 180 total points
ID: 35082557
either don't specify the block size
or make it the same value as what you have db_block_size parameter
or make it the same value as one of the db_Nk_cache_size parameters

look in v$parameter for these values


look in chapter 1 of the reference manual for more info on the parameter usage
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/toc.htm
0
 
LVL 6

Expert Comment

by:anumoses
ID: 35082599
Once the caches are defined then you can define the  tablespaces
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now