incremental export-import question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: incremental export-import question

  1. #1
    Join Date
    Mar 2001
    Posts
    286
    I am in a situation that needs to recover a table from incrementa backups.

    Assume that you have the following situation:

    One complete export called X1

    Two cumulative exports called C1 and C2

    Three incremental exports called I1, I2, and I3

    Then you should import in the following order to get the full database back:

    imp system/manager INCTYPE=SYSTEM FULL=Y FILE=I3
    imp system/manager INCTYPE=RESTORE FULL=Y FILE=X1
    imp system/manager INCTYPE=RESTORE FULL=Y FILE=C1
    imp system/manager INCTYPE=RESTORE FULL=Y FILE=C2
    imp system/manager INCTYPE=RESTORE FULL=Y FILE=I1
    imp system/manager INCTYPE=RESTORE FULL=Y FILE=I2
    imp system/manager INCTYPE=RESTORE FULL=Y FILE=I3

    Question: How do I import only one table instead of "Full=Y"?


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check this link: ON import parameters....

    http://www.oradoc.com/ora816/server.816/a76955/ch02.htm

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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