Hi all.
We received a ZIP file from our ERP solution provider with the information of our database in order to feed other application for BI. The file we received is a ZIP file with the following contents:
Both files are binary files, but I expected to find a CTL loader file... AFAIK, they exported it with some tool from a Oracle 19.5c SGDB.
If I cat the CTL file (filtering strings) I find something like this:
RDB$FUNCTIONS
RDB$FIELD_POSITION
RDB$SENTRYPOINT
RDB$FUNCTIONS
RDB$EXTERNAL_NAME
...
This is onlty the beggining, in points of the file can view the functions/procedures created, etc.
I tried to use SQL*Loader to import it without success, it is very large, it does not begin with LOAD keyword, etc.
In total, the CTL file is 38MB sized, it is not a big file but should contain all the information I need to replicate the structure and data in a new DDBB.
My questions are several:
- I couldn't find information about this file format, anyone can give me more information about the file and its format?
- Is there a way to recreate a DDBB from this file.
Thank you in advance.