用友NC的资料

t666777888

nc开发的资料，给大家传一份，嘿嘿nc创建oracle数据库时的sql脚本：

(表空间为nnc_data1、nnc_data2、nnc_data3、
nnc_index1、nnc_index2、nnc_index3，假定用户为weiqiao)
一，建立表空间和用户：
在服务器上安装oracle9.2.0.1后,首先运行sqlplus:
“Oracle - OraHome92”——“Application Development”——“SQL Plus”：
用户名称：system
口令：输入密码(密码为安装时自己定义的)
主机字符串：安装时输入的sid（密码为安装时自己定义的实例名）
连接成功后，输入：
--建立表空间，e盘就是那个足够大的分区：
先在E:\ 新建文件夹 oracle
create tablespace NNC_DATA01 datafile 'E:\oracle\NNC_DATA01.ora' size 1024M autoextend on
NEXT 32M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;
create tablespace NNC_DATA02 datafile 'E:\oracle\NNC_DATA02.ora' size 200M autoextend on
NEXT 32M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;
create tablespace NNC_DATA03 datafile 'E:\oracle\NNC_DATA03.ora' size 1024M autoextend on
NEXT 32M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;
create tablespace NNC_INDEX01 datafile 'E:\oracle\NNC_INDEX01.ora' size 1024M autoextend on
NEXT 32M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;
create tablespace NNC_INDEX02 datafile 'E:\oracle\NNC_INDEX02.ora' size 200M autoextend on
NEXT 32M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;
create tablespace NNC_INDEX03 datafile 'E:\oracle\NNC_INDEX03.ora' size 1024M autoextend on
NEXT 32M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;
--建立用户weiqiao,密码abc,并予以授权：
create user NC502 identified by nc502 default tablespace NNC_DATA01 temporary tablespace temp;
grant connect,dba,resource to weiqiao with admin option;
--退出
exit;
二、导入dmp数据：
然后再后在命令提示符下输入:
imp weiqiao/abc@服务id file=database.dmp fromuser=aa touser=weiqiao ignore=y full=y
（database.dmp就是那个12g的导出文件,aa就是那个当初导出dmp文件时候的用户）
之后即可将数据导入到用户weiqiao里了（怎么地也得2个小时以上，即便是1GB的内存）。


CREATE USER weiqiao IDENTIFIED BY password;  
alter user weiqiao identified by weiqiao;

asdfasdf

呵呵,看不懂啊

cofecooking

一般都是复制~黏贴~修改下~OK~

呵呵·具体没看懂

grwmaster

太专业了，看不懂啊

zhouciqin

太专业了，看不懂！

xiao99306353

怎么没有SQL的

happysmhzp

sql server 的

USE master;
go
IF DB_ID (N'NCDB') IS NOT NULL
DROP DATABASE [NCDB];
go
CREATE DATABASE [NCDB]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX03]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data01', FILENAME = N'C:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_data01_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data02', FILENAME = N'C:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_data02_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data03', FILENAME = N'C:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_data03_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index01', FILENAME = N'C:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_index01_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index02', FILENAME = N'C:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_index02_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index03', FILENAME = N'C:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_index03_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX03]
Go

wa_roro

等下试试 呵呵

♀絀人頭地♂

太专业了啊

◇╮小子没人爱

很好！谢谢你了