Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    9

    Unanswered: How can duplicate Scott's Tables?

    Dear Friends,

    How can I copy all the tables along with its constraints from Scott's Schema. When I try to create table in new schema with foll. query, the table is created without constraints:

    create table emp as select * from scott.emp;

    I want to create a copy of all the tables from Scott Schema along with its constraints in my new user's schema.

    Thanks in advance.
    Rakesh.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: How can duplicate Scott's Tables?

    Originally posted by rakesh300
    Dear Friends,

    How can I copy all the tables along with its constraints from Scott's Schema. When I try to create table in new schema with foll. query, the table is created without constraints:

    create table emp as select * from scott.emp;

    I want to create a copy of all the tables from Scott Schema along with its constraints in my new user's schema.

    Thanks in advance.
    Rakesh.
    export from scott schema & then import into new schema

Posting Permissions

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