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

Report message to a moderator

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: 21823
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.

Report message to a moderator

Previous Topic: Tunning of SQLLDR control file
Next Topic: Policy - function_schema is not exp/imp properly
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 07:29:14 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.