0

I want to create a new database on a remote Oracle server, I see an example from the post Create Oracle database and schema programmatically ADO.NET, but in this post the database is on a local server:

string oracleDataPath = "C:\\PATH_TO_ORADATA\\";

I need to do the same but on a remote server.

Thanks in advance for help me.

Improve this question
6
  • Creating an entire database is an installation task so probably belongs on dba.stackexchange.com. What is an Oracle Server? Commented Aug 15, 2019 at 21:00
  • 1
    If you really want to create an Oracle database, you may be out of luck. If the database doesn't already exist, ADO has nothing to connect to. If we assume that you're using the enterprise edition 12.1 or later and that the server already has an Oracle CDB installed and that you want to create a PDB in that CDB then it would be possible. Or if you're really just trying to create a schema (with or without a tablespace) as the linked question does, that would be possible. Or maybe you're trying to do something else... Commented Aug 15, 2019 at 21:13
  • What version of Oracle are you using? Commented Aug 15, 2019 at 23:34
  • Oracle 11g R2, but I want to create the program independent of what database is. It has to be done, if it can be done on a local server, it should be able to be done on a remote server. I already did it with SQL Server. Commented Aug 16, 2019 at 7:19
  • Not sure what you are looking for. The command will always be executed on and by the server, not the client. You do however need to know where a specific server stores the database files. Commented Aug 16, 2019 at 10:49
Related questions
8
How do I create a database programmatically in SQL Server?
0
How to programatically create a database from an ADO.Net Entity Model?
1
ADO.NET for connecting Oracle Database on server
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.