DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: To migrate from DMT to LMT

Hybrid View

  1. 05-03-2005, 04:01 AM #1
    yls177
    yls177 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    391

    To migrate from DMT to LMT

    Hi, to do what the subject says, check this out "DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL"

    cheers
    Reply With Quote Reply With Quote
  2. 05-03-2005, 04:04 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    whats your point?

    YOu know that method isn;t very good as you miss out on some of the benefits of LMT's
    Reply With Quote Reply With Quote
  3. 05-03-2005, 04:30 AM #3
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    create the TS (LMT) and then move all the objects..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  4. 05-04-2005, 05:39 AM #4
    yls177
    yls177 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    391
    Originally posted by davey23uk
    whats your point?

    YOu know that method isn;t very good as you miss out on some of the benefits of LMT's
    Hi. Cos i know the benefits of LMT, that is why i wanted to convert from DMT.
    Reply With Quote Reply With Quote
  5. 05-04-2005, 05:44 AM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well dont use that method then, its not a good way of doing it
    Reply With Quote Reply With Quote
  6. 05-04-2005, 06:39 AM #6
    OracleDoc's Avatar
    OracleDoc
    OracleDoc is offline The Doc is in!
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    I have a homework assignment for you my young yls177.

    Find out why running that migrate to loacal package is a bad idea
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg
    Reply With Quote Reply With Quote
  7. 05-04-2005, 06:56 AM #7
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Folks

    whats wrong with that method just curios ?

    regards
    Hrishy
    Reply With Quote Reply With Quote
  8. 05-04-2005, 07:02 AM #8
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    will wait to see what yls177 comes back with for his homework first
    Reply With Quote Reply With Quote
  9. 05-04-2005, 07:16 AM #9
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by hrishy
    Hi Folks

    whats wrong with that method just curios ?

    regards
    Hrishy

    U may loose the benifit of uniform extents.


    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  10. 05-04-2005, 07:46 AM #10
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    booooo, you told him and to be more precise you won't lose uniform extents you just cant enforce them. A user can still enter whatever storage parameters they want.

    Existing extents wont suddenly become uniform and initial=next and pctincrease=0 still isn't uniform

    Also the bitmaps are in the wrong place as well so they aren't good
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width