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

---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