Home » RDBMS Server » Backup & Recovery » how to recover truncated table using import mode
how to recover truncated table using import mode [message #159270] Fri, 17 February 2006 01:46 Go to next message
oradba16
Messages: 54
Registered: September 2005
Member
hi,
i hav a table called 'employee' with columns.

desc employee;
empno not null number(4)
ename varchar2(10)
job varchar2(9)
mgr number(4)

unknowingly i truncate the datas from the table.
but i hav backup for that table now i want to import only rows into that table as the table structure is available there.
is it possible to import only rows into that table? instead using flashback or logminer.....

Report message to a moderator

Re: how to recover truncated table using import mode [message #159340 is a reply to message #159270] Fri, 17 February 2006 08:35 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
using imp like this:

imp userid=user/passwd file=xxx.dmp tables=(your_drop_table) ignore=Y

Report message to a moderator

Previous Topic: RMAN-06580 the fileperset cannot be used with AS COPY
Next Topic: restore whole backup with RMAN. help me!!!!!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 17 20:23:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.