How do I export an Oracle database (into a single file) and install it on a client machine without i-CodePudding

I am trying to create a windows desktop application ( point of sales) using Delphi for the software and i want to use oracle for the database part, so I have installed "Oracle Database XE program " on my dev machine, i will work on the default XE pluggable database ( create my tables and functions) and to connect to the database from Delphi using UniDAC , so when i finish my application i want to deliver it to a client ,this client has only one machine and has no access to any network . so is there a way to export the oracle database in to a single file and then copy that file to the application folder and connect to the file using the UniDAC so when i deliver the application to the client i will install only my application so i do not have to install the "Oracle Database XE program".

so is there a way to export the oracle database in to a single file and then copy that file to the application folder and connect to the file using the UniDAC so when i deliver the application to the client i will install only my application so i do not have to install the "Oracle Database XE program".

CodePudding user response：

That won't work, in my opinion. You can export that schema (see Data Pump utility, both Export and Import) and get a .dmp file, but it is to be imported into target database.

If your application requires Oracle database, how do you plan to make it work on your customer's computer without a database? As Express Edition (XE) is free to use, why wouldn't you (or customer) install that database so that they would use that application without any problems?

CodePudding user response：

Silent installation still requires installing the database on the customer's computer, but it can be done without any customer input. All of the configuration options can be chosen ahead of time via a configuration file and command line arguments.

And I'm sure you can combine the silent installation with one of the many Windows installers to build a single .EXE that will unzip the Oracle setup files, run the setup.exe command, install the Delphi pieces, etc.