Home » RDBMS Server » Server Utilities » import of user's table (oracle 10g ,AIZ 5.2)
import of user's table [message #525613] Tue, 04 October 2011 02:32 Go to next message
Messages: 86
Registered: June 2009
Location: india

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 #525618 is a reply to message #525613] Tue, 04 October 2011 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68310
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export is not a database backup.

How to import?
Use "imp" or "impdp" command with the appropriate options.
"imp help=y" or "impdp help=y" will give you the syntax.


[Updated on: Tue, 04 October 2011 02:41]

Report message to a moderator

Re: import of user's table [message #525620 is a reply to message #525613] Tue, 04 October 2011 02:39 Go to previous message
Messages: 21750
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.
Previous Topic: Sql Loder Issues
Next Topic: Error in Import
Goto Forum:

Current Time: Sun Nov 27 00:24:59 CST 2022