OraFAQ Forum: Server Administration » error-ora 2097/384 (non std tablespace creation)

Home » RDBMS Server » Server Administration » error-ora 2097/384 (non std tablespace creation)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error-ora 2097/384 (non std tablespace creation) [message #55484]

Mon, 27 January 2003 06:17

Anu
Messages: 82
Registered: May 2000

Member

I am trying to create a tablespace with non std block size.
The db_cache_size is set to 25165824. I reduced this buffer_cache size to 25133056 to add db_4k_cache_size= 32768 parameter. The server doesn't allow me to do so and throws a message ora-29339.

The systax I am typing is:

create tablespace ns_test
datafile 'c:oracleoradataoracle9ns&#124_test.dbf' size 12k
blocksize 4k
/

Any clues where 'am going wrong...??

Any assistance in this regard shall highly be appreciated.

cheers

Anu

Report message to a moderator

Re: error-ora 2097/384 (non std tablespace creation) [message #55485 is a reply to message #55484]

Mon, 27 January 2003 06:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

create tablespace ns_test
datafile 'c:oracleoradataoracle9ns&#124_test.dbf' size 12k
blocksize 4k

are u sure u want to create a tablespace with 12k datafile?

Report message to a moderator

Re: error-ora 2097/384 (non std tablespace creation) [message #55487 is a reply to message #55484]

Mon, 27 January 2003 06:36

Anu
Messages: 82
Registered: May 2000

Member

I am just trying to test the functionality...a reason I hv set the db_4k_cache_size=32k.
Is this a probable cause of error...??
Pls clarify

Regards,

Anu.

Report message to a moderator

Previous Topic:	Storage indexes in different Tablespaces
Next Topic:	ORACLE Enterprise Manager / Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:30:26 CDT 2024