导入数据库:DMP
1.创建TABLESPACE
CREATE TABLESPACE "SPACE" LOGGING DATAFILE 'F:\oracle\product\10.1.0
\oradata\bpbj\SPACE.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 1280K
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT
AUTO;
2。导入DMP
imp userid=xxx/xx fromuser=xx touser=xxfile=e:\db\xxxxDB.dmp
3。DELETE USER
drop user tssa cascade;
4。创建用户
create user xxx identified by xxxx default tablespace xxxxSPACE
temporary tablespace TEMP;
create user xxx identified by xxxx default tablespace xxxSPACE
temporary tablespace TEMP;
grant dba to sxbpbj;
commit;
keim,毕业于安徽科技学院理学院,2003年开始对Web开发有浓厚的兴趣,并专注于C#/java Web开发,软件架构设计、分布式相关、项目管理、前端设计等等,实战派...