Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    9

    Unanswered: Scripts to copy all objects of a schema

    Hello !

    Does anyone have a little script to copy all the objects of a schema (table, procedure, view, trigger ...) to a new one ?
    Is it possible to copy the tables with the data ?
    Sorry for my silly question but ... I'm not a DBA !

    Thx

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    You can use the import/export ulitity for this.

    Just make an export of the schema, and import it into the new schema
    (imp fromuser=oldschema touser=newschema etc..)

    Ruud
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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