CONFIGURAR BASE DE DATOS ORACLE ANTES DE INSTALAR ALFRESCO 4.X

Esta configuración la realize antes de intalar Alfresco en una base de datos Oracle, espero les sirva si alguien tiene sugerencias para mejorar bienvenidas Saludos --Crear un tablespace para los datos

CREATE TABLESPACE "TS_ALFRESCO" LOGGING

DATAFILE 'C:\app\Oracle\product\11.1.0\db_1\oradata\alfresco\ALFRESCODAT.dbf' SIZE 200M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

--Crear un tablespace para los indices

CREATE TABLESPACE "TS_ALFRESCO_IDX" LOGGING

DATAFILE 'C:\app\Oracle\product\11.1.0\db_1\oradata\alfresco\ALFRESCOIDX.dbf' SIZE 200M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

--Crear el usuario que va a trabajar sobre estos tablespace

CREATE USER "ALFRESCOUSER" PROFILE "DEFAULT" IDENTIFIED BY "ALFRESCOPWD"

DEFAULT TABLESPACE "TS_ALFRESCO" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;

--Asignacion de permisos para el usuario ALFRESCOUSER

GRANT "CONNECT" TO "ALFRESCOUSER"

GRANT "RESOURCE" TO "ALFRESCOUSER"

--permisos complementarios

GRANT ALTER ANY INDEX TO "ALFRESCOUSER";

GRANT ALTER ANY SEQUENCE TO "ALFRESCOUSER";

GRANT ALTER ANY TABLE TO "ALFRESCOUSER";

GRANT ALTER ANY TRIGGER TO "ALFRESCOUSER";

GRANT CREATE ANY INDEX TO "ALFRESCOUSER";

GRANT CREATE ANY SEQUENCE TO "ALFRESCOUSER";

GRANT CREATE ANY SYNONYM TO "ALFRESCOUSER";

GRANT CREATE ANY TABLE TO "ALFRESCOUSER";

GRANT CREATE ANY TRIGGER TO "ALFRESCOUSER";

GRANT CREATE ANY VIEW TO "ALFRESCOUSER";

GRANT CREATE PROCEDURE TO "ALFRESCOUSER";

GRANT CREATE PUBLIC SYNONYM TO "ALFRESCOUSER";

GRANT CREATE TRIGGER TO "ALFRESCOUSER";

GRANT CREATE VIEW TO "ALFRESCOUSER";

GRANT DELETE ANY TABLE TO "ALFRESCOUSER";

GRANT DROP ANY INDEX TO "ALFRESCOUSER";

GRANT DROP ANY SEQUENCE TO "ALFRESCOUSER";

GRANT DROP ANY TABLE TO "ALFRESCOUSER";

GRANT DROP ANY TRIGGER TO "ALFRESCOUSER";

GRANT DROP ANY VIEW TO "ALFRESCOUSER";

GRANT INSERT ANY TABLE TO "ALFRESCOUSER";

GRANT QUERY REWRITE TO "ALFRESCOUSER";

GRANT SELECT ANY TABLE TO "ALFRESCOUSER";

GRANT UNLIMITED TABLESPACE TO "ALFRESCOUSER";

-- crear un esquema de la base de datos

 CREATE SCHEMA AUTHORIZATION ALFRESCOUSER;

Si es el caso que instalamos algo mal y necesitamos borrar las tablas que creamos ejecutamos el siguiente script o los drop directamente --borrar las tablas de un esquema

SELECT 'DROP TABLE '||table_name||' CASCADE CONSTRAINTS;'

FROM ALL_TABLES

WHERE owner='ALFRESCOUSER';

SELECT 'DROP TABLE '||table_name||' CASCADE CONSTRAINTS;' FROM user_tables

SELECT 'DROP VIEW '||VIEW_NAME||';' FROM user_views

SELECT 'DROP SEQUENCE '|| SEQUENCE_NAME||';' FROM user_sequences

DROP TABLE ALF_NAMESPACE CASCADE CONSTRAINTS;

DROP TABLE ALF_APPLIED_PATCH CASCADE CONSTRAINTS;

DROP TABLE ALF_BOOTSTRAP_LOCK CASCADE CONSTRAINTS;

DROP TABLE ACT_ID_INFO CASCADE CONSTRAINTS;

DROP TABLE ACT_ID_USER CASCADE CONSTRAINTS;

DROP TABLE ACT_ID_MEMBERSHIP CASCADE CONSTRAINTS;

DROP TABLE ACT_ID_GROUP CASCADE CONSTRAINTS;

DROP TABLE ACT_HI_ATTACHMENT CASCADE CONSTRAINTS;

DROP TABLE ACT_HI_COMMENT CASCADE CONSTRAINTS;

DROP TABLE ACT_HI_DETAIL CASCADE CONSTRAINTS;

DROP TABLE ACT_HI_TASKINST CASCADE CONSTRAINTS;

DROP TABLE ACT_HI_ACTINST CASCADE CONSTRAINTS;

DROP TABLE ACT_HI_PROCINST CASCADE CONSTRAINTS;

DROP TABLE ACT_RU_EVENT_SUBSCR CASCADE CONSTRAINTS;

DROP TABLE ACT_RU_VARIABLE CASCADE CONSTRAINTS;

DROP TABLE ACT_RU_IDENTITYLINK CASCADE CONSTRAINTS;

DROP TABLE ACT_RU_TASK CASCADE CONSTRAINTS;

DROP TABLE ACT_RE_PROCDEF CASCADE CONSTRAINTS;

DROP TABLE ACT_RU_JOB CASCADE CONSTRAINTS;

DROP TABLE ACT_RU_EXECUTION CASCADE CONSTRAINTS;

DROP TABLE ACT_RE_DEPLOYMENT CASCADE CONSTRAINTS;

DROP TABLE ACT_GE_BYTEARRAY CASCADE CONSTRAINTS;

DROP TABLE ACT_GE_PROPERTY CASCADE CONSTRAINTS;