start e:\mydata\oracle\ac01or;
start e:\mydata\oracle\ac02or;
start e:\mydata\oracle\acortrg;

drop user :oracle_user cascade;

drop user :oracle_user cascade;

create user :oracle_user identified by :oracle_password default tablespace :oracle_user temporary tablespace temp quota unl...  
grant connect, resource, ctxapp, javasyspriv, query rewrite to :oracle_user;
revoke unlimited tablespace from :oracle_user;

create user :oracle_user identified by :oracle_password default tablespace :oracle_user temporary tablespace temp quota unl...  
grant connect, resource, ctxapp, javasyspriv, query rewrite to :oracle_user;
revoke unlimited tablespace from :oracle_user;

@ ddl/oracle-se/table-acs_objects-auto.sql
@ ddl/oracle-se/table-acs_permissions-auto.sql
@ ddl/oracle-se/table-acs_privileges-auto.sql

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_create_shared_tables_oracle.sql,v 1.8 2007/11/07 04:51:13 tdanard Exp $
 */
select '/framework/core/shared/install/oracle/install_all_create_shared_tables_oracle.sql' from dual;

@ ddl/oracle-se/table-acs_object_lifecycle_map-auto.sql
@ ddl/oracle-se/table-authoring_kit_step_map-auto.sql
@ ddl/oracle-se/table-authoring_steps-auto.sql

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_shared_oracle.sql,v 1.2 2006/04/22 23:04:05 tdanard Exp $
 */
select '/main-wiki/shared/install/oracle/install_all_shared_oracle.sql' from dual;

select version from PRODUCT_COMPONENT_VERSION
where product like 'Oracle%'

oracle:
create sequence sq_dummy
postgresql:

oracle:
create sequence sq_dummy
postgresql:

oracle:
create sequence sq_dummy
postgresql:

oracle:
create sequence sq_dummy
postgresql:

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_create_geography_tables_oracle.sql,v 1.2 2007/01/03 17:43:28 tdanard Exp $
 */
select '/framework/core/geography/install/oracle/install_all_create_geography_tables_oracle.sql' from dual;

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_create_organization_tables_oracle.sql,v 1.3 2007/01/03 17:43:30 tdanard Exp $
 */
select '/framework/core/organization/install/oracle/install_all_create_organization_tables_oracle.sql' from dual;

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_shared_oracle.sql,v 1.3 2007/01/03 17:43:30 tdanard Exp $
 */
select '/workflow/shared/install/oracle/install_all_shared_oracle.sql' from dual;

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_create_proxy_tables_oracle.sql,v 1.2 2007/01/03 17:43:30 tdanard Exp $
 */
select '/framework/core/proxy/install/oracle/install_all_create_proxy_tables_oracle.sql' from dual;

CREATE ALIAS dump FOR "com.knowledgesuccess.testframework.sqlj.hsql.SqljEmulateOracle.dump"
CREATE ALIAS to_date FOR "com.knowledgesuccess.testframework.sqlj.hsql.SqljEmulateOracle.to_date"

CREATE ALIAS dump FOR "com.knowledgesuccess.testframework.sqlj.hsql.SqljEmulateOracle.dump"
CREATE ALIAS to_date FOR "com.knowledgesuccess.testframework.sqlj.hsql.SqljEmulateOracle.to_date"

CREATE ALIAS dump FOR "com.knowledgesuccess.testframework.sqlj.hsql.SqljEmulateOracle.dump"
CREATE ALIAS to_date FOR "com.knowledgesuccess.testframework.sqlj.hsql.SqljEmulateOracle.to_date"

// example: SQL getOracleLocks.sql <dbuser> <dbpassword>
#QUERY_FILE .out
select * from user_tables;

-- rights and limitations under the License.
--
-- $Id: //core-platform/dev/sql/ccm-core/upgrade/oracle-se-5.1.2-5.2.0.sql#2 $
-- $DateTime: 2004/03/30 17:47:27 $
@@ ../oracle-se/upgrade/5.1.2-5.2.0/function-currentDate.sql

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_create_shared_tables_oracle.sql,v 1.4 2007/07/11 22:41:54 tdanard Exp $
 */
select '/framework/helpdesk/shared/install/oracle/install_all_create_shared_tables_oracle.sql' from dual;

-- rights and limitations under the License.
--
-- $Id: //cms/dev/sql/ccm-cms/upgrade/oracle-se-5.1.0-5.2.0.sql#2 $
-- $DateTime: 2004/03/30 18:05:08 $
@@ ../oracle-se/upgrade/5.1.0-5.2.0/function-convert_to_html.sql