| import of user's table [message #525613] |
Tue, 04 October 2011 02:32  |
oradba123
Messages: 86
Registered: June 2009
Location: india
|
Member |
|
|
Hi all,
we have every day full export backup in eacly morning. but some tables's data has been delete unforutnaltely
& structure of these tables intact. please anyone can suggest me how do i import only some tables of a user from
daily full export backup? . this has to be done immdediately. quick response will be highly appreciated.
Best Regards
|
|
|
|
|
|
| Re: import of user's table [message #525620 is a reply to message #525613] |
Tue, 04 October 2011 02:39  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
This is how you might do that (an example, using "real" credentials, table names, and - note the IGNORE=Y parameter):imp scott/tiger@ora10 file=my_export.dmp tables=(emp, dept) ignore=y
For more information (and, above all, more accurate information), provide some more details - how do you perform export? Is it "traditional" exp/imp utility, or is it data pump? Anyway: 10g Utilities contain all you need.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
