recover oracle table data from single tablespace datafile

Posted by PDSERVICE on Feb 23, 2021 In

while lost system tablespace using dbrecover for oracle

SINGLE.DBF a user data tablespace

start dbrecover for oracle

=> non dictionary mode

use need to select correct characterset here.

Now you can see lots of tables named OBJXXXXX, which is a combination of “OBJ” and

DATA_OBJECT_ID. We need some technicians who are familiar with schema design

and application data, they can match this table with application tables through browsing

sample data analysis.

then you can use databrige , transfer table data into your new database !

ok!

You are here