Question on changing to Oracle DB from standard install

[npereira]

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 but does not indicate how to setup the schema on Oracle as far as the table structure.

Can anyone point me to how to do this?

Thanks

NP

[mrogers]

http://docs.alfresco.com/4.0/index.jsp

Please see the "Configuring databases" page.

[npereira]

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.

[mrogers]

Just create an empty schema and give alfresco permissions to use it.   The rest will happen automatically,  in particular you don't create the tables yourself.

[npereira]

Thanks, will try this.