oracle 11g 导出到10g

最新推荐文章于 2021-12-15 18:10:48 发布

higher_gao

最新推荐文章于 2021-12-15 18:10:48 发布

阅读量314

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/higher_gao/article/details/43669945

版权

数据库专栏收录该内容

1 篇文章 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