topic Question on changing to Oracle DB from standard install in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258504#M211634 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>New to Alfresco. </SPAN><BR /><BR /><SPAN>installed the enterprise 4.0.0 and did the advanced, yet said yes to everything.</SPAN><BR /><BR /><SPAN>By default this is setup with Postgresql, but I need to change it to change this to Oracle. I have looked at the wiki and it only talks about changing the alfresco-global.properties for 2 strings but does not indicate how to setup the schema on Oracle as far as the table structure.</SPAN><BR /><BR /><SPAN>Can anyone point me to how to do this?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>NP</SPAN></BODY></HTML> Fri, 03 Feb 2012 20:45:31 GMT npereira 2012-02-03T20:45:31Z Question on changing to Oracle DB from standard install https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258504#M211634 Hi all,New to Alfresco. installed the enterprise 4.0.0 and did the advanced, yet said yes to everything.By default this is setup with Postgresql, but I need to change it to change this to Oracle. I have looked at the wiki and it only talks about changing the alfresco-global.properties for 2 strings Fri, 03 Feb 2012 20:45:31 GMT https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258504#M211634 npereira 2012-02-03T20:45:31Z Re: Question on changing to Oracle DB from standard install https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258505#M211635 <HTML><HEAD></HEAD><BODY><A href="http://docs.alfresco.com/4.0/index.jsp" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.0/index.jsp</A><BR /><BR /><SPAN>Please see the "Configuring databases" page.</SPAN></BODY></HTML> Fri, 03 Feb 2012 21:29:14 GMT https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258505#M211635 mrogers 2012-02-03T21:29:14Z Re: Question on changing to Oracle DB from standard install https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258506#M211636 <HTML><HEAD></HEAD><BODY><SPAN>did you actually read the document? It does not tell you how to setup the schema (tables) in Oracle. this is what I'm trying to figure out. I need to change the DB from Postgresql to Oracle, but need more info then what is provided in the docs.</SPAN></BODY></HTML> Fri, 03 Feb 2012 22:01:21 GMT https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258506#M211636 npereira 2012-02-03T22:01:21Z Re: Question on changing to Oracle DB from standard install https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258507#M211637 <HTML><HEAD></HEAD><BODY><SPAN>Just create an empty schema and give alfresco permissions to use it.&nbsp;&nbsp; The rest will happen automatically,&nbsp; in particular you don't create the tables yourself.</SPAN></BODY></HTML> Sat, 04 Feb 2012 12:30:36 GMT https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258507#M211637 mrogers 2012-02-04T12:30:36Z Re: Question on changing to Oracle DB from standard install https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258508#M211638 <HTML><HEAD></HEAD><BODY><SPAN>Thanks, will try this.</SPAN></BODY></HTML> Mon, 06 Feb 2012 13:19:39 GMT https://connect.hyland.com/t5/alfresco-archive/question-on-changing-to-oracle-db-from-standard-install/m-p/258508#M211638 npereira 2012-02-06T13:19:39Z