title: Can I create a brand new oracle db/schema with roundhouse?
body: <p>I am a bit new to Oracle, having used mostly SQL, so some of my understanding of how oracle works and what users/connection strings to use might be wrong or non existant.</p>
  
  <p>I am trying to use roundhouse to create/manage an Oracle database. For now I am trying to get to work on my dev machine running Windows 7 and VS 2010. I have a simple sandbox project where I am trying to create a test database. I have installed Oracle 11g standard edition on my machine.</p>
  
  <p>First question is, would I even be able to create a brand new database (the Oracle db tells me they are called 'Schemas' in Oracle) using roundhouse? From my understanding, unlike SQL server, there is no <code>Master</code> database with an <code>sa</code> user who can create any database.</p>
  
  <p>I found the wiki page for Oracle on the roundhouse site, but it only talks about modifying an existing Oracle database, not creating a new one. I am having trouble finding examples where a brand new database was created in Oracle using roundhouse before creating the required tables, stored procs etc. </p>
  
  <p>If it is possible, what do I need to do / setup? How should I set up my configuration file? Given is my current configuration file.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;Project DefaultTargets="DBDeploy" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"&gt;
    &lt;!-- Visit http://roundhouse.googlecode.com/ for details --&gt;
  
    &lt;UsingTask AssemblyFile="roundhouse.tasks.dll" TaskName="roundhouse.tasks.Roundhouse" /&gt;
  
    &lt;PropertyGroup&gt;
      &lt;DBServer&gt;dev-mac-303.qtest.local&lt;/DBServer&gt;
      &lt;DBName&gt;RoundhouseSandbox.OracleRoundhouse&lt;/DBName&gt;
      &lt;Environment&gt;DEV&lt;/Environment&gt;
      &lt;DBConnectionString&gt;Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dev-mac-303.qtest.local)(PORT = 1521)))(CONNECT_DATA = (SID = DEVEL)));User Id=mytest;Password=mytestdevel;Persist Security Info=false;&lt;/DBConnectionString&gt;
    &lt;/PropertyGroup&gt;
  
  
    &lt;Target Name="ApplyDatabaseChanges"&gt;
      &lt;Roundhouse
          ServerName="$(DBServer)"
          DatabaseName="$(DBName)"
          ConnectionString="$(DBConnectionString)"
          ConnectionStringAdmin="$(DBConnectionString)"
          CommandTimeout="60"
          CommandTimeoutAdmin="300"
          VersionFile="OracleRoundhouse.dll"
          AlterDatabaseFolderName="alterDatabase"
          UpFolderName="mytest\updates"
          RunFirstAfterUpFolderName="mytest\runFirstAfterUp"
          FunctionsFolderName="mytest\functions"
          ViewsFolderName="mytest\views"
          SprocsFolderName="mytest\storedprocedures"
          IndexesFolderName="mytest\indexes"
          PermissionsFolderName="mytest\permissions"
          SchemaName="Change"
          VersionTableName="Version"
          ScriptsRunTableName="ScriptsRun"
          ScriptsRunErrorsTableName="ScriptsRunErrors"
          EnvironmentName="$(Environment)"
          DoNotCreateDatabase="false"
          OutputPath="C:\temp\test.mytest.Database\ChangeTracking\"
          WarnOnOneTimeScriptChanges="false"
          Silent="true"
          DatabaseType="roundhouse.databases.oracle.OracleDatabase, roundhouse.databases.oracle"
          WithTransaction="false"
          RunAllAnyTimeScripts="false"
          DisableTokenReplacement="false"
          Debug="true"
          /&gt;
    &lt;/Target&gt;
  
    &lt;Target Name = "DBDeploy"
            DependsOnTargets="
          ApplyDatabaseChanges;
        "
       &gt;
    &lt;/Target&gt;
  
  &lt;/Project&gt;
  </code></pre>