Home » RDBMS Server » Server Administration » segment space managent is auto (oracle10g AIX)
segment space managent is auto [message #479484] Mon, 18 October 2010 00:42 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member


Hi all,

can any one tell me the syntax to make a tablespace's segment space mnagement auto which is segement management is *manual* and exent management is *local autoallocate*.


Best regards

Report message to a moderator

Re: segment space managent is auto [message #479493 is a reply to message #479484] Mon, 18 October 2010 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No syntax, recreate the tablespace.

Regards
Michel

[Updated on: Mon, 18 October 2010 10:03]

Report message to a moderator

Re: segment space managent is auto [message #479532 is a reply to message #479484] Mon, 18 October 2010 04:46 Go to previous message
surachart
Messages: 19
Registered: December 2008
Junior Member
you can check from oracle doc.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/physical.htm#i5042

I think this explains more me.

Report message to a moderator

Previous Topic: Sun solaris - Oracle server Load Average is too High at specific days
Next Topic: ERROR
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 05:41:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.