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

公良昕
2023-12-01

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 [NC61]

go

CREATE DATABASE [NC61]

go

ALTER DATABASE [NC61] ADD FILEGROUP [NNC_DA TA01]

go

ALTER DATABASE [NC61] ADD FILEGROUP [NNC_DA TA02]

go

ALTER DATABASE [NC61] ADD FILEGROUP [NNC_DA TA03]

go

ALTER DATABASE [NC61] ADD FILEGROUP [NNC_INDEX01]

go

ALTER DATABASE [NC61] ADD FILEGROUP [NNC_INDEX02]

go

ALTER DATABASE [NC61] ADD FILEGROUP [NNC_INDEX03]

go

ALTER DATABASE [NC61] ADD FILE(NAME = N'nnc_data01', FILENAME = N'F:\NC61BD\nnc_data01_Data.NDF' , SIZE = 800, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA01]

go

ALTER DATABASE [NC61] ADD FILE(NAME = N'nnc_data02', FILENAME = N'F:\NC61BD\nnc_data02_Data.NDF' , SIZE = 800, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA02]

go

 类似资料: