-
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"?
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
|