用友nc633与oracle,用友NC63安装到SQL server 2008 R2和oracle上的表空间创建语句

NC安装到oracle的表空间创建SQL语句：

alter system set "_optimizer_cartesian_enabled"=false;

alter system set "_b_tree_bitmap_plans"=false;

alter system set "_optimizer_skip_scan_enabled"=false;

CREATE TABLESPACE NNC_DA TA01 DATAFILE

'E:\app\Administrator\oradata\ncdata\nnc_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT

50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE NNC_INDEX01 DATAFILE

'E:\app\Administrator\oradata\ncdata\nnc_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE USER NC63ZS IDENTIFIED BY nc633 DEFAULT TABLESPACE NNC_DA TA01 TEMPORARY TABLESPACE temp;

GRANT connect,dba to NC63ZS;

NC安装到SQL server 2008 R2上的表空间创建语句，对应到NC61：

USE master

go

IF DB_ID (N'NC61') IS NOT NULL

DROP DATABASE [N