exporting schema
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: exporting schema

  1. #1
    Join Date
    Aug 2000
    Posts
    11
    Hi All

    I need to make a schema on dev server same as prod server. Right now the schema on dev server is missing some objects. What is the best way of doing this?

    Thanks in advance.

  2. #2
    Join Date
    Jul 2000
    Posts
    243
    do you need to keep the diff between dev and prod or do you whant to copy prod on dev no metter what?

  3. #3
    Join Date
    Aug 2000
    Posts
    11
    I dont want to keep dev server different, as I need to test some reports on dev server which needs to have the same schema as prod server.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    PROD
    1)exp system/****
    buffer=65536
    owner=sch_user
    consistent=y

    DEVT
    2)imp sysem/****
    buffer=65536
    fromuser=sch_user
    touser=sch_user
    ignore=y
    Reddy,Sam

  5. #5
    Join Date
    Aug 2000
    Posts
    11
    One more doubt I have is about tablespaces, they are different on dev and prod servers. How can I specify different tablespace name when importing in dev server.

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