Q: How can I migrate the oracle datasource on the server to other machines?

A: 1. Use PL/SQL tool or command to export all the tables under the oracle datasource to dmp files. 2. Create the user and tablespace for the oracle datasource on the target machine. 3. Import the dmp files on the target machine. Note: The import of dmp files cannot be performed in the sqlplus window. The import should be executed on the CMD terminal.

09 Jul,2019

More iDesktop FAQ