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

Hybrid View

  1. #1
    Join Date
    Feb 2001

    INCTYPE Export On Individual Tables?

    I need to export some specific tables from 1 database to another in Oracle 8.1.5 on Solaris 8. The source db is our production db. I don't need all the tables in our production db, since we are just moving the tables for a specific app.
    I'd like to do a full export of the tables, move them to the new database, then "shutdown" access to the db from the app and do a cumulative export of any changes since the full export.
    I thought I could do this with export using INCTYPE=complete on each table, then use INCTYPE=cumlative at shutdown time, but Oracle reports a EXP-00021: can only perform incremental export in Full Database mode error.
    I would perfer not to export the Full database as there is tables I don't want or need. I just need to move specific tables to the new database, with a minimum of down time and be happy doing it.
    Any ideas?
    Ken Hammer

  2. #2
    Join Date
    Jul 2002
    Lake Worth, FL
    In any case, INCTYPE=cumulative will export all the data for a changed table, not only the changed rows.

    You are better off exporting the whole table everytime.

  3. #3
    Join Date
    Feb 2001
    We are trying to limit the down time of the application that these tables support. It takes about 2-3 hours to export the tables.
    By doing a cumulitive for the second export, we get just the rows that change, and this is what we want.
    Ken Hammer

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.