Need to attach oracle dbf to database

Asked By 10 points N/A Posted on -


I need to attach oracle dbf to database. I have some oracle data file which contain data table that i want to attach in to oracle database. how can i attach oracle dbf to database?

Answered By 30 points N/A #148918

Need to attach oracle dbf to database


Hi Leslie Joshuaa,

I think a little bit of more information will help to assist you correctly. It is important to know where or which version of Oracle your dbf belongs to. Other information required is in which version of Oracle database you want to attach the dbf.

As I don't have the required information I am going to give you a general idea on how things work at Oracle while attaching an old dbf file into the new version of the Oracle database.

There is a dictionary information in the system which describes how they are laid out, how the segment was, their names etc. These are essential information for attaching dbf into new DB. The metadata from dictionary normally do not reside in the dbf.

So, you need to use the EXP tool in the older version to 'transport' the table space into the newer version. In this process it will create a dmp file with the required metadata. Then you can copy the dbf & reattach to a newer version.

If you have already used the EXP tool to create the dmp file then you can just reattach the file in the new database.

If you haven't then you need to create the dmp file using above mentioned process.

Hope it's clear your confusion.

Thanks & Regards,




Related Questions