当前位置:操作系统 > Unix/Linux >>

配置表空间、建立用户、导入数据库

配置表空间、建立用户、导入数据库
 
---cmd 进入dos界面 

sqlplus / as sysdba 

----建立表空间 ---dbf文件时自己手动建立的 
CREATE TABLESPACE ciqpspace 
DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\CIQP.DBF' size 30M reuse AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED 
EXTENT MANAGEMENT LOCAL AUTOALLOCATE 
SEGMENT SPACE MANAGEMENT AUTO; 
--建立用户 
create user fqs identified by "1" 
default tablespace fqs01 
temporary tablespace temp; 
grant connect, resource to fqs; 
grant unlimited tablespace to fqs; 
grant dba to fqs; 

create tablespace mcsspace 
logging 
datafile 'e:\mcs20130415.dmp' 
size 50m 
autoextend on 
next 50m maxsize 20480m 
extent management local; 
imp ciqpf/ciqpf@orcl file=e:/ciqp20130413.dmp full=y 
create tablespace mcsspace 
size 50m 
autoextend on 
next 50m maxsize 20480m 
extent management local; 

C:\Documents and Settings\Administrator>exp ciqp/ciqp@orcl_251  file=e:/ciqp2013 
0412.dmp 
imp full=y 
exp mcs/1@orcl_251  file=e:/mcs.dmp 
imp mcs/mcs@orcl file=e:/mcs.dmp full=y 

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,