oracle 11g 导出到10g

清疚 2022-08-06 17:24 217阅读 0赞

//登录数据库 sqlplus user1/pw1@evcorcl  
sqlplus /nolog  
conn sys as sysdba  
  
  
//删除掉数据库  
drop user  user1 cascade  
drop user  user1 cascade  
drop user  user1 cascade  
  
  
  
  
select \* from dba\_tablespaces  
  
  
//删除表空间  
DROP TABLESPACE INX\_SOTOWER INCLUDING CONTENTS AND DATAFILES;  
DROP TABLESPACE TBS\_EVCAS INCLUDING CONTENTS AND DATAFILES;  
DROP TABLESPACE INX\_EVCAS INCLUDING CONTENTS AND DATAFILES;  
DROP TABLESPACE evcas INCLUDING CONTENTS AND DATAFILES;  
  
  
//增加表空间  
CREATE TABLESPACE INX\_SOTOWER LOGGING DATAFILE '/opt/oracle/oradata/evcorcl/INX\_SOTOWER.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M EXTENT MANAGEMENT LOCAL;  
CREATE TABLESPACE TBS\_EVCAS   LOGGING DATAFILE '/opt/oracle/oradata/evcorcl/TBS\_EVCAS.DBF' SIZE 2000M AUTOEXTEND ON NEXT 32M EXTENT MANAGEMENT LOCAL;  
CREATE TABLESPACE INX\_EVCAS   LOGGING DATAFILE '/opt/oracle/oradata/evcorcl/INX\_EVCAS.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M EXTENT MANAGEMENT LOCAL;  
CREATE TABLESPACE evcas       LOGGING DATAFILE '/opt/oracle/oradata/evcorcl/EVCAS.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M EXTENT MANAGEMENT LOCAL;  
CREATE USER "SOTOWER" PROFILE "DEFAULT" IDENTIFIED BY "sotower" DEFAULT TABLESPACE "EVCAS" TEMPORARY TABLESPACE "TEMP"  ACCOUNT UNLOCK;  
GRANT "CONNECT" TO "SOTOWER";  
GRANT "DBA" TO "SOTOWER";  
CREATE USER "EVCASDBA" PROFILE "DEFAULT" IDENTIFIED BY "EVCASDBA"  DEFAULT TABLESPACE "EVCAS" TEMPORARY TABLESPACE "TEMP"  ACCOUNT UNLOCK;  
GRANT "CONNECT" TO "EVCASDBA";  
GRANT "DBA" TO "EVCASDBA";  
CREATE USER "EVCAS" PROFILE "DEFAULT" IDENTIFIED BY "EVCAS"  DEFAULT TABLESPACE "EVCAS" TEMPORARY TABLESPACE "TEMP"  ACCOUNT UNLOCK;  
GRANT "CONNECT" TO "EVCAS";  
GRANT "DBA" TO "EVCAS";  
  
  
//开始数据导入  
imp userid=evcas/evcas@evcorcl fromuser=evcas touser=evcas file=F:\\79数据库备份\\to10g\\evcas.dmp log =F:\\79数据库备份\\to10g\\evcas.log  
imp userid=evcasdba/evcasdba@evcorcl fromuser=evcasdba touser=evcasdba file=F:\\79数据库备份\\to10g\\evcasdba.dmp log =F:\\79数据库备份\\to10g\\evcasdba.log  
imp userid=sotower/sotower@evcorcl fromuser=sotower touser=sotower file=F:\\79数据库备份\\to10g\\sotower.dmp log =F:\\79数据库备份\\to10g\\sotower.log