dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Threaded View

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

    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-21-2004 at 11:40 PM.
    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




×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.