怕丢失,所以就写在这里保存了
更新数据库
drop user user1 cascade;
create user user1 identified by user1;grant dba to user1;
imp system/system@orcl file='c:\1.dmp' fromuser=user1 touser=user1
创建表空间:
create tablespace mpm datafile 'mpm.dbf' size 1024m;
怕丢失,所以就写在这里保存了
更新数据库
drop user user1 cascade;
create user user1 identified by user1;grant dba to user1;
imp system/system@orcl file='c:\1.dmp' fromuser=user1 touser=user1
创建表空间:
create tablespace mpm datafile 'mpm.dbf' size 1024m;