Home » SQL & PL/SQL » SQL & PL/SQL » how to alter the blocksize value ? (oracle10g)
how to alter the blocksize value ? [message #317295] Wed, 30 April 2008 06:56 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
How to alter the blocksize in tablespaces.

my tablespce scripts:
********************
CREATE TABLESPACE TBS DATAFILE
<path> SIZE 102M AUTOEXTEND ON NEXT 1M MAXSIZE 2048M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 104K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;

I need to alter the blocksize.How cn resolve the problem?


Thanks,
Michael
Re: how to alter the blocksize value ? [message #317296 is a reply to message #317295] Wed, 30 April 2008 06:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't ALTER the block size. It defined at tablespace (or database) creation time and can't be modified.

Regards
Michel
Re: how to set the pctfree value in create tablespace script. [message #317319 is a reply to message #317296] Wed, 30 April 2008 08:26 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I need to set the PCTFREE value in create tablespace script.

my script:

CREATE TABLESPACE TBS DATAFILE
<path> SIZE 102M AUTOEXTEND ON NEXT 1M MAXSIZE 2048M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 104K

above scripts pctfree is 10% but i need to change the 0.

how can resolve this problem?

Thanks,
Michael
Re: how to set the pctfree value in create tablespace script. [message #317321 is a reply to message #317319] Wed, 30 April 2008 08:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER TABLESPACE

Regards
Michel
Re: how to set the pctfree value in create tablespace script. [message #317326 is a reply to message #317319] Wed, 30 April 2008 08:45 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
Is any possible to set pctfree parameters in create tablespace scripts?


Thanks,
Michael
Re: how to set the pctfree value in create tablespace script. [message #317327 is a reply to message #317326] Wed, 30 April 2008 08:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is possible, see the syntax.

Regards
Michel
Re: how to set the pctfree value in create tablespace script. [message #317329 is a reply to message #317327] Wed, 30 April 2008 08:51 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry no it is not possible, pctfree is one of the storage parameters that can't be set by default.

Regards
Michel
Previous Topic: Insert Trigger
Next Topic: ORA-30484: missing window specification for this function
Goto Forum:
  


Current Time: Sun Dec 11 08:15:45 CST 2016

Total time taken to generate the page: 0.23443 seconds