| READ ONLY Tablespace - Free Space [message #304346] |
Tue, 04 March 2008 23:48  |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi,
I want to make some tablespaces READ_ONLY in my Datawarehose Environment.
At present these tablespaces having more than 40% Free space.
I want to reduce this space and want to maintain just 5% Free space.
Are there any guidelines to maintain how much Free Space required in READ ONLY tablespaces.
Thanks,
Brian
|
|
|
|
|
|
| Re: READ ONLY Tablespace - Free Space [message #304382 is a reply to message #304366] |
Wed, 05 March 2008 00:47  |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
You can try following options:
(a) you can use alter database datafile '<path+file_name>' resize <size>M;remember that you can only shrink upto the high water mark of your datafile else you get ORA-03297.
(b) Create a new tablespace and use alter table move command to move all the table to the new one
then drop the old tablespace. than make it read only.
| Quote: | Are there any guidelines to maintain how much Free Space required in READ ONLY tablespaces.
|
No specific rules for free space in readonly tablespaces, only your choice is best guide.
Regards
Manjit Kumar [mkbhati]
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
