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

Thread: Copy all table data from one schema to another

Threaded View

  1. 11-02-2009, 03:08 PM #5
    giteshtrivedi
    giteshtrivedi is offline Junior Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    57
    Hi,

    You can use CTAS (create table b as select from a)

    Thanks and regards,
    Gitesh Trivedi
    Last edited by davey23uk; 11-02-2009 at 04:09 PM.
    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