数据库导入imp格式

数据库导入imp格式 Create tablespace hrcdj datafile 'd:\tablespace\hrcdj.dbf' size 500M autoextend on next 50M ; Create user hrc identified by hrc default tablespace hrcdj quota unlimited on hrcdj; Grant resource, dba, create table, create view, create trigger, select any table, create sequence, create procedure, create role, grant any privilege, drop any role to hrc; Create tablespace hrqdb datafile 'd:\tablespace\hrqdb.dbf' size 500M autoextend on next 50M ; Create user hrq identified by hrq default tablespace hrqdb quota unlimited on hrqdb; Grant resource, dba, create table, create view, create trigger, select any table, create sequence, create procedure, create role, grant any privilege, drop any role to hrq; Create tablespace jxdb datafile 'd:\tablespace\jxdb.dbf' size 500M autoextend on next ; 50M Create user jx identified by jx default tablespace jxdb quota unlimited on jxdb; Grant resource, dba, create table, create view, create trigger, select any table, create sequence, create procedure, create role, grant any privilege, drop any role to jx; Create tablespace hrmdj datafile 'd:\tablespace\hrmdj.dbf' size 500M autoextend on next 50M ; Create user mdj identified by mdj default tablespace hrmdj quota unlimited on hrmdj; Grant resource, dba, create table, create view, create trigger, select any table, create sequence, create procedure, create role, grant any privilege, drop any role to mdj; Create tablespace factdb datafile 'd:\tablespace\factdb .dbf' size 500M autoextend on next 50M ; Create user fact identified by fact default tablespace factdb quota unlimited on factdb ; Grant resource, dba, create table, create view, create trigger, select any table, create sequence, create procedure, create role, grant any privilege, drop any role to fact; : Create tablespace hrcdj(表空间名) datafile 'd:\tablespace\hrcdj.dbf'(表空间文件物理位 next 50M (如果表空间不够用以50m自动置) size 500M (表空间大小) autoextend on 递增) ; Create user hrc(用户名) identified by hrc(密码) default tablespace hrcdj(给hrc定义默认表空间) quota unlimited(无额度限定) on hrcdj; Grant resource, dba, create table, create view, create trigger, select any table, create sequence, create procedure, create role, grant any privilege, drop any role to hrc;(给hrc赋予行权限) drop user hrc cascade;//删除用户及其表 drop tablespace hrcdj ;//删除表空间'd:\tablespace\hrcdj.dbf' 需手动删除。 select username, default_tablespace from user_users;// 查询默认表空间。