I am very new to Oracle and customer gave us their oracle database files.
ARC00016_0724940467.001
initVISUAL.ora
VISUAL.2010-07-22-1637.log
VISUAL-trace.sql
SYSAUX01.DBF
SYSTEM01.DBF
UNDOTBS01.DBF
USERS01.DBF
I am running Oracle personal edition. I want to create a new database using the above files and connect to it using ODBC and VB.NET.
Any help is greatly appreciated.
Thanks
Best Answer
You won't get there from here.
Either make sure that your version, edition and operating system are the same as the client. If so, you may get away with doing a restore from a physical copy of the data files (DBF) and control files.
If not, you are best off asking for a database export (either old-fashioned exp, or preferably a datapump export). That is a 'logical' copy of the tables/data etc and it is much easier to pull that into a different environment.