| shikhu |
Posted: Jul 17, 2007 04:43:20 AM |
Total Post: 61
Joined: Jul, 2006
|
Hi All
1.Can we alter the segemtnspace management from maual(by default) to auto
2.I have 1 yr. of exp. in DBA mode (Oracle9i) I want some interview questions(of DBA mode in Oracle 9i as well as for Oracle 10g) of 1 yr. of exp.
Its urgent!!!!!!!!!
- shikha
|
|
|
 Nand |
| Posted: Jul 17, 2007 06:56:37 AM |  |
|
Total Post: 22
Joined: Jun, 2007
|
Shikhaa..
We can convert from ASM to manual and vice versa. Follow this link:
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_33.shtml
About the interview questions...if u find any, do give me the link
Regards
Nand
|
|
|
|
|
| dipali |
| Posted: Jul 20, 2007 07:13:42 AM | |
|
Total Post: 31
Joined: Dec, 2006
|
Hey nand..
sheekha is taking about segment space management..
While ASM is totally different thing.. itz Automatic Storage Management..
@sheekha..
yes, you can .. But automatic segment space management is not available for temp an system tablespace..
|
|
|
|
|
| Nand |
| Posted: Jul 21, 2007 12:43:11 AM | |
|
Total Post: 22
Joined: Jun, 2007
|
OOPS My Mistake...
Sorry for that ....
Dipali, we cant change from manual to auto ssm or vice versa. What we can do is create a new tablespce with asm and move the data into this newly created tablespace.
Regards
Nand
|
|
|
|
|
| DreamzZ |
| Posted: Jul 23, 2007 03:10:48 PM | |
|
Total Post: 23
Joined: Jul, 2007
|
yes you can change it in 10g.
goto Em then Administration then tablespaces and then reoraganize.
|
|
|
|
|
| Mohammed Taj |
| Posted: Jul 29, 2007 12:06:17 PM | |
|
Total Post: 704
Joined: Jul, 2007
|
@DreamZ
You cann't change SEGMENT SPACE MANAGEMENT manual to auto from EM or not through SQL*PLUS command line.
We have to recreate tablespace for change segment space management
<quote>The segment space management that you specify at tablespace creation time applies to all segments subsequently created in the tablespace. You cannot change the segment space management mode of a tablespace.</quote>
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#ADMIN10065
Regards
Taj
http://dbataj.blogspot.com
|
|
|
|
|
| DreamzZ |
| Posted: Jul 30, 2007 05:52:37 PM | |
|
Total Post: 23
Joined: Jul, 2007
|
Dear taj
Again check the EM..You will get it. log from EM
======================================
The tablespace attributes that can be modified during reorganization are shown on this page. Make any attribute changes and click OK.
Extent Allocation
Automatic
Uniform
Size (KB)
Segment Space Management
Automatic
Objects in the tablespace automatically manage their free space. It offers high performance for free space management.
Manual
Objects in the tablespace will manage their free space using free lists. It is provided for backward compatibility.
|
|
|
|
|
| DreamzZ |
| Posted: Jul 30, 2007 05:58:05 PM | |
|
Total Post: 23
Joined: Jul, 2007
|
Here are step to change from manual to AUTO using Em
1:Administration
2:tablespaces
3:Select tablespace
4:slect Reoraganize from combobox.
5:select SET ATTRIBUTES.
6:CHOOSE THE OPTION AUTO
AND THEN NEXT AND NEXT....
I'm 100% sure because i did it for more than 200 tablespaces.
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 08:47:06 PM | |
|
Total Post: 416
Joined: Jun, 2008
|
It is mandatory to specify at creation time.Modification later on is not possible.
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
