| C# Application to backup Schema to .dmp file [message #676838] |
Sun, 21 July 2019 19:57  |
 |
Dandaman
Messages: 15
Registered: July 2019
|
Junior Member |
|
|
Hi I am trying to figure out the best approach that a c# application on a end users desktop could backup an Oracle database schema.
End user does not have Oracle or any Oracle tools installed.
Have been trying to run SQL dbms_datapump to create the dmp and log file in a folder accessible to the Oracle database server.
I generate my SQL command in c# console application and run it via
command.ExecuteNonQuery();
But I keep getting the error
"ORA-00922: missing or invalid option".
When I copy and paste the SQL that I output to the console and run within SQL Developer on the Oracle Database server the script runs without error.
So the question is what don't I understand?
Is it the method in which the SQL is sent to the Oracle server that causes the script to fail?
Regards Dan.
(At the end of the line of researching and seeking guidance.)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
