1

Topic: Obtaining of the information from tabular spaces

Hello! Forgive for small cry from the heart.
To me  set very interesting task. Its essence in creating basis on the basis of available files of tabular spaces (files with DBF extension). How many I had time to subtract from various sources, files DBF "especial" and unlike standard DBF them cannot be taken and opened Oracle simply MS EXCEL. On the other hand, all is stored in them: tables, keys etc.
And here at me a question to community: whether probably it to make? Whether if Oracle means to receive the information from these dbf files?
If I can receive at least contents of tables, it already will be a victory in my opinion.
I thank for attention.

2

Re: Obtaining of the information from tabular spaces

Yes all mission of a DBMS of Oracle consists in obtaining and a data recording in these files

3

Re: Obtaining of the information from tabular spaces

DmSide wrote:

Hello! Forgive for small cry from the heart.
To me  set very interesting task. Its essence in creating basis on the basis of available files of tabular spaces (files with DBF extension). How many I had time to subtract from various sources, files DBF "especial" and unlike standard DBF them cannot be taken and opened Oracle simply MS EXCEL. On the other hand, all is stored in them: tables, keys etc.
And here at me a question to community: whether probably it to make? Whether if Oracle means to receive the information from these dbf files?
If I can receive at least contents of tables, it already will be a victory in my opinion.
I thank for attention.

Files  in  not "especial", they at all have no relation to "standard" DBF.

4

Re: Obtaining of the information from tabular spaces

Whether

DmSide wrote:

probably it to make?

Even though any success is not guaranteed. And in case of a teapot - generally a pipe.

5

Re: Obtaining of the information from tabular spaces

DmSide, Messir
Read 1 head of Oracle Concepts and start to understand in what you are going to be got involved.
Short, very roughly and :
Oracle database - file set + a dial-up of processes
dbf files - binary files dataful, belong to one of tabular spaces
+ system tabular space - the system dictionary of objects of basis
+ undo tabular space - segments of rollback of transactions
+ redo files - logs of advancing record
+ Additional files temp, bfile and some other
It is necessary to divide logic level:
- Object,
- Tabular space,
- The circuit,
- Record
And physical level:
File
The unit
In an operating time, a DBMS forms so-called SCN (System Change Number) - temporal labels. The same unit / a set of records in it can during the same moment of time in basis can have some not fixed states (with miscellaneous SCN). At the moment of fixing commit, this unit is written in redo, and commit complete session receives only during the moment when the vector  the data registers in a disk in a file redo. Thus actually changed unit of a file registers in the place afterwards when it will be convenient for a DBMS (checkpoit). So-called delayed write.
Not fixed data is stored in cache block, thus, the old data (which are used at recoil/rollback)  in a logical type (a change vector) in undo
In case of failure, at start, the basis , writes down all changes stored in redo on units of tabular spaces (files) and  them for one moment of time/SCN
Fulfills the physical coordination of files
After that, for the logical coordination, regular image rolls away not complete transactions using the information from undo. And only after that the basis opens and it is possible to obtain the data from a DBMS.
Thus, to open basis for reading, it is necessary for you:
1) a software of a DBMS of Oracle of that version and the same OS (not absolutely so, but now on it we we will not stop) on which the basis (Including patches worked)
2) to provide a coordination of all file set, that is to have file set of the data + a dial-up redo for the physical coordination of basis.
To lift the remained FULL! File set, it is necessary to have skills DBA.
Approximate disaster volume:
Operation of cloning of basis, than that is similar to your task.
Good luck!

6

Re: Obtaining of the information from tabular spaces

DmSide wrote:

.
To me  delivered

You not so understood setting. And can it is simple you far sent.

7

Re: Obtaining of the information from tabular spaces

DmSide;
.. That there at you for the task also that for files is available. But suddenly.... Suddenly is "cold" ?
Then it is possible to try variants from here ...