数据库初始化

//查看 数据导出目录
select * from dba_directories;
 
//创建数据导出目录
create or replace directory oms_exp_path as 'D:\oms_exp'


//导出 数据  
EXPDP com/lsd123456@neadb  DIRECTORY=DIR DUMPFILE=COM_2015-03-23.DUMP LOGFILE=COM_2015-03-23..LOG SCHEMAS=COM,NYJ_NYXM,NYJ_AUDIT,NYJ_GJNY,NYJ_NYGK,NYJ_NYXS

//输入用户名
sys/sys@orcl as sysdba

/*********************************初始化新的数据库************************************************/
2、//创建表空间
create tablespace com datafile 'C:\APP\ADMINISTRATOR\ORADATA\NYJ\COM.DBFF' size 200m
autoextend on next 10m maxsize 1g;

create temporary tablespace temp1 tempfile 'C:\APP\ADMINISTRATOR\ORADATA\NYJ\TEMP1.DBF' SIZE 500M 
TABLESPACE GROUP TMPGRP;


ALTER TABLESPACE TEMP TABLESPACE GROUP TMPGRP;



// 修改临时表空间 
alter database tempfile 'C:\APP\ADMINISTRATOR\ORADATA\NYJ\TEMP1.DBF'
autoextend on next 100M maxsize unlimited


//创建OMS数据库
create tablespace OMS
datafile 'C:\APP\ADMINISTRATOR\ORADATA\NYJ\OMS.DBF' size 50M
autoextend on next 10M maxsize unlimited logging
extent management local autoallocate
segment space management auto;


创建临时表空间
create temporary tablespace OMS_TEMP
tempfile 'C:\APP\ADMINISTRATOR\ORADATA\NYJ\OMS_TEMP.DBF' size 30M
autoextend on next 10M maxsize 100M


grant execute on dbms_crypto to com;

3、//导入数据
//导入数据库
IMPDP sys/sys@NYJ  DIRECTORY=OMS_EXP_PATH DUMPFILE=EXP_OMS_2014-10-20_2.DUMP LOGFILE=exp_oms_2014-10-20_2.LOG SCHEMAS=OMS,COM,NYJ_NYXM,NYJ_AUDIT,NYJ_GJNY,NYJ_NYGK,NYJ_NYXS
full=y


sys/sys@NYJ as sysdba