oracle数据库如何配置表空间,配置表空间、建立用户、导入数据库-Oracle

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

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