创建表空间:
create tablespace PMSPHASE2
logging
datafile 'E:\oracle\product\10.2.0\PMS\PMSPHASE2.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
2.修改表空间的大小
alter database datafile 'E:\oracle\product\10.2.0\PMS\PMSPHASE2.DBF' resize 10240M;
3. 创建用户并给用户授权
create user mypms identified by pms ;
grant create session,connect,resource,dba to mypms;
或:
(
grant create session to 用户名;
grant create table to 用户名;
grant create tablespace to 用户名;
grant create view to 用户名;
)
4. 创建用户并给给用户指定表空间:
create user username identified by password
default tablespace user_data
temporary tablespace user_temp;
5.修改用户表空间:
alter user pms default tablespace PMSPHASE2;
-
将 dmp 文件导入到 oracle 数据库中:
-
将所有的表导入到 oracle :
imp mypms/pms@orcl file=F:\pms_20140707_pms_oracle11gdatabase.dmp full=y ignore=y log=e:\T.log
-
将部分表导入到 oracle :
imp system/manager@TEST file=d:\daochu.dmp tables=(table1,table2)
-
将一个用户的表,导入到另外一个用户中:
IMP SONIC/SONIC BUFFER=64000 FILE=C:\SONIC.DMP FROMUSER=SONIC TOUSER=SONIC log=exp_icdmain_yyyymmdd.log
-