| About Incremental Backup/Restore [message #72210] |
Sun, 13 April 2003 00:37  |
M. Khaled
Messages: 67
Registered: April 2002
|
Member |
|
|
Is it possible to take only the incremental portion of a database.Using export/import ,It takes the whole table if is incremented. In oracle 8i query option may be used for taking subset of a table.
My requirement is to take the whole database(Only the incremental portion)
Please help.........
|
|
|
|
| Re: About Incremental Backup/Restore [message #72211 is a reply to message #72210] |
Mon, 14 April 2003 01:00  |
Muhammad Waqas Shabir
Messages: 26
Registered: April 2003
|
Junior Member |
|
|
Dear khalid!
Yes it is possible to take incremental (only new changes) backup.
Type this command on your command prompt:
For Incremental export:
exp username/password file=pathfilename.dmp inctype=incremental full=y grants=y compress=n log=pathfilename.log
Note:the username should be a user with export rights.
For Incremental import:
imp username/password file=pathfilename.dmp inctype=restore full=y ignore=y destroy=y grants=y log=pathfilename.log
NOTE:the username that you have mentioned in imp command must have import rights.
VIP TIP:you should import in ascending order otherwise you will be in a big trouble. i.e if you have taken two exports one on yesterday and one today THEN take the import of yesterday's export first and then of today's.
GoodLuck!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
