Hi, hopefully it will help.
first you must had a clean cold backup on tape/disk.
Basically you need to create a temporary instance to contain the affected
table the least of anything else.
1. copy the following files from tape/disk to a different server:
(1)all redo log files.
(2)all control files
(3)the datafile that has the table
(4)system tablespace files
(5)user tablespace files
2. edit the init.ora file to update the control file path, remove the
rollback_segments entry (because there is no user created rollback segments,
only system rollback segment), and change shared_pool_size, buffers (because
the production database is very large so I need to shrink the SGA for this
tempoarary database).
3. mount the database
4. offline drop all other datafiles that have nothing to do the affected table.
5. rename redo log files to the current name
6. rename system tablespace file to the current name
7. rename user tablespace file to the current name.
8. open the database
9. export the table
10. import the table
have a nice try and goodluck
Ferry Setiawan <[EMAIL PROTECTED]> wrote:
Dear All,
Bagaimana caranya untuk merestore table yang sudah terlanjur di truncate?
Versi Oracle nya 9i, OS nya Win xp
Thanks
Ferry Setiawan
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
[Non-text portions of this message have been removed]
