Home » RDBMS Server » Server Utilities » export and import issue (oracle on IBM AIX 5.2 )
export and import issue [message #438711] Mon, 11 January 2010 23:17 Go to next message
Messages: 86
Registered: June 2009
Location: india


i have last two day full export backup.but my question is can i import individual or a specific table from a full export backup beacuse i need the two day old table, we don't have the before two days backup of that table and database is not flash back mode. any suggestion or advice higly appreciated.

Re: export and import issue [message #438736 is a reply to message #438711] Tue, 12 January 2010 00:41 Go to previous message
Messages: 21670
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, you can. Use TABLES identifier (and, possibly - as it is a full export - FROMUSER and TOUSER as well).

For a little bit more information, type IMP HELP=Y at the command prompt. For a lot more information, check the documentation.
Previous Topic: Tunning of SQLLDR control file
Next Topic: Policy - function_schema is not exp/imp properly
Goto Forum:

Current Time: Mon May 10 18:03:34 CDT 2021