Project development completed, need to move the database to the user's machine, originally I wanted to use expdp export backup, and then get a client impdp, but now there is a demand, said customers what all don't understand, let make a button to automatically install the database, specific, assume that the customer has been properly installed oracle, I do a small tool, such as dialog box, a button, what to rebuild the database, create a path, the database backup recovery and so on are made by small tool automatically, on the client automatically let database was set up, don't appear the CMD, up sqlplus that black white interface,
I received completely, hope masters to a train of thought, refers to the way, don't have to use impdp, only can automatically set on the client database, to complete the demand, can give a best routines, thanks!

CodePudding user response:

Should be customer no full-time technical staff,

Simple speaking, if only to create, can make all a SQL statement, point a button, connect to the database, and perform this pile of SQL,

If asked to do the backup and restore, can consider to encapsulate imp and exp to your gadgets, (do not use expdp and impdp),