DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

[Oracle] Very Simple Way To Recreate A Table With Contents Between Schemas

04.19.2007
| 5753 views |
  • submit to reddit
        User must have both schema permissions to execute this query

CREATE TABLE schema.table AS SELECT * FROM schema.table