System Tablespace as Local Managed
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: System Tablespace as Local Managed

  1. #1
    Join Date
    Sep 2001
    Posts
    261

    Question

    Guys,

    What's the corect syntax for creating locally managed SYSTEM tablespace using the CREATE DATABASE command?

    Thanks.
    The Maverick
    Oracle Certified DBA - 8i

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Sorry you cannot have a sytem tablespace as locally managed.

    regards
    Hrishy

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by D Maverick
    Guys,

    What's the corect syntax for creating locally managed SYSTEM tablespace using the CREATE DATABASE command?

    Thanks.
    Not possible even in the near future (for many reasons).


  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Ok, I'm curious. WHY on earth would you want to do that?
    MH

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Because LMTs are so damn cool people just can't get enough of them

    This is not possible in 9i either!
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  6. #6
    Join Date
    Sep 2001
    Posts
    261
    Actually i was also curious about it, i read it from -

    Sybex OCP: Oracle8i DBA
    Architecture & Administration and Backup & Recovery Study Guide by Doug Stuns & Biju Thomas

    Page 153 (Managing Tablespaces)

    "The SYSTEM tablespace can be locally managed; you must specify the EXTENT MANAGEMENT LOCAL clause in the CREATE DATABASE command."

    Thank you for the clarification, i guess the author of the book was drunk when he wrote that section.
    The Maverick
    Oracle Certified DBA - 8i

  7. #7
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    More like I was drunk!

    It does appear to be a valid option in 9i during creation. You just can't migrate a dictionary managed system tablespace after creation.

    I'm creating one now to test that it isn't a mistake. Sorry for throwing you off the scent!

    Sorry :(
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  8. #8
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    It works! I now have a 9i instance with a Locally Managed System Tablespace.

    Please form an orderly queue to kick me square in the nuts!
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  10. #10
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is an extract fromMetalink

    Code:
    
    
    CREATING A LOCALLY MANAGED SYSTEM TABLESPACE
    --------------------------------------------
     
    The Oracle 8i Concepts guide page. 3-8, states that you can specify that 
    the system tablespace be created as locally managed by including the extent 
    management local clause in your create database script......It states as 
    follows:
    
    "For the SYSTEM tablespace, you can specify EXTENT MANAGEMENT LOCAL in the 
    CREATE DATABASE command"
    
    The truth however, is that neither Oracle version 8.1.5 OR 8.1.6 supports 
    the concept of a locally managed system tablespace.
    
    In Oracle 8.1.5, any attempt to add the EXTENT MANAGEMENT LOCAL clause to 
    your create database command will result in a syntax error OR an 
    ORA-600 [3810] error.  In Oracle 8.1.6, any attempt to do so, results in 
    no error....But the clause is ignored. In 8.1.7 an ORA-2165 is returned when 
    using the clause in the create database command.
    
    Locally managed system tablespaces are simply not yet possible.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width