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



Hi,

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.



BEST REGARDS
Re: export and import issue [message #438736 is a reply to message #438711] Tue, 12 January 2010 00:41 Go to previous message
Littlefoot
Messages: 20901
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: Sun Dec 11 06:29:46 CST 2016

Total time taken to generate the page: 0.19523 seconds