配置表空间、建立用户、导入数据库
配置表空间、建立用户、导入数据库
---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