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