Import - overwriting existing tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import - overwriting existing tables

  1. #1
    Join Date
    Jan 2001
    Posts
    66
    I have a very outdated test database ORACLE_SID=test. I have a current development database ORACLE_SID=dbdev.

    dbdev has tables that have been modified. The same table name exists in test but with original/non-modified version.

    Can I export/import into test and have it over-write the existing out-of-date table.

    I was not able to find an import parameter that supports this situation. If this can not be done by import what is the easiest way to perform this task. If worse comes to worse I can identify the db files solely containing this info.

    Help.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The easiest way is to drop all your existing tables in test and import them from dbdev. Use something like http://home.adelphia.net/~marist89/s...ipe_schema.htm to drop every object for a particular user.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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