DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import - overwriting existing tables

  1. 02-20-2002, 05:56 PM #1
    thomgreen
    thomgreen is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 02-20-2002, 06:24 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width