oracle如何导入数据库

来源:互联网 发布:字体临摹软件 编辑:程序博客网 时间:2024/05/14 12:12
以下是导入数据库的命令:
删除命名空间 drop tablespace CHINESE including contents and datafiles cascade constraints;首先用户 drop user CHINESE cascade;再执行,CREATE TABLESPACE CHINESE--建立表空间    LOGGING    DATAFILE 'D:\app\Administrator\oradata\CHINESE\DEMO_20151015.DBF' SIZE 1G--单引号中的文件为随机文件,可以自行指定位置    AUTOEXTEND ON NEXT 100M MAXSIZE 2G    EXTENT MANAGEMENT LOCAL    SEGMENT SPACE MANAGEMENT AUTO;CREATE USER CHINESE--建立用户    PROFILE DEFAULT    IDENTIFIED BY CHINESE    DEFAULT TABLESPACE CHINESE    TEMPORARY TABLESPACE TEMP    QUOTA UNLIMITED ON CHINESE    ACCOUNT UNLOCK;ALTER USER CHINESE DEFAULT ROLE  ALL;GRANT CONNECT,      CREATE PROCEDURE,      CREATE TRIGGER,      ANALYZE ANY,      CREATE TYPE,      SELECT ANY DICTIONARY,      CREATE VIEW,      CREATE SEQUENCETO CHINESE;GRANT ALTER ANY TABLE TO CHINESE;GRANT DROP ANY TABLE TO  CHINESE;GRANT DELETE ANY TABLE TO  CHINESE;GRANT SELECT ANY TABLE TO  CHINESE;GRANT INSERT ANY TABLE TO  CHINESE;GRANT CREATE ANY TABLE TO  CHINESE;GRANT CREATE TYPE TO CHINESE;GRANT CREATE PUBLIC DATABASE LINK TO CHINESE;GRANT DROP PUBLIC DATABASE LINK TO CHINESE;GRANT DBA TO CHINESE;数据泵工具导出的步骤:1、创建DIRECTORYcreate directory DR_DBIMP as 'D:\DR_DBIMP';--导入的数据库所在的位置2、授权Grant read,write on directory DR_DBIMP to CHINESE;以下这句话在“运行”中输入cmd后,执行;不是在sqlplus中执行impdp CHINESE/CHINESE@CHINESE directory=DR_DBIMP DUMPFILE=DEMO_20151015.DMP LOGFILE=DEMO_20151015.log  REMAP_SCHEMA=(CS42DEMO:CHINESE) REMAP_TABLESPACE=(CS42DEMO:CHINESE)。REMAP_SCHEMA=(CS42DEMO:CHINESE) REMAP_TABLESPACE=(CS42DEMO:CHINESE),这句话冒号前边的是原来的用户和表空间,冒号后面的是现在建立的用户和表空间


                                             
0 0