Move a table from one schema to another
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Move a table from one schema to another

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Move a table from one schema to another

    Hi all
    I have TOAD related tables created under my application schema. I wanted to create a new schema called TOAD and move all TOAD table from the application owner schema into TOAD schema.

    I know you can use the MOVE commnand to move tables from one tablespace to another. Can it be used as well in the context of one schema to another?

    Please advise
    Thanks
    Last edited by Ablakios; 01-22-2004 at 12:40 AM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Aug 2002
    Posts
    115
    exp/imp

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Move a table from one schema to another

    Originally posted by Ablakios
    I know you can use the MOVE commnand to move tables from one tablespace to another. Can it be used as well in the context of one schema to another?
    No
    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"

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks for the response.

    If I was to use the export/import with the fromuser=x touser=y .
    It will import all of the table from user x to y, then I have to go back to x schema and drop all of the tables(about 70) that I do not want in that schema right ?

    Is there any simplier way just get the 70 tables out of that schema rather the whole list of tables? I see that I have the
    list the name of all the tables
    tables= table1,table2,table3,table4xxxxxxxxx
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    use CTAS -> very simple..very fast..very relaiable
    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"

  6. #6
    Join Date
    Aug 2002
    Posts
    115
    ...else exp tables=(t1,t1..)

  7. #7
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks for the response.EXP/IMP worked just fine.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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