给我一个SQL脚本,一个数据备份文件(payroll.dmp)。如何在本地ORACLE数据库里导入,具体步骤是什么:脚本内容如下:
--PAYROLL_DAT TABLESPACE CREATION
CREATE TABLESPACE PAYROLL_DAT DATAFILE
'D:\DATABASE\ORACLE\ORCL\PAYROLL_DAT.DBF' SIZE 10000M AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
/ --PAYROLL_IDX TABLESPACE CREATION
CREATE TABLESPACE PAYROLL_IDX DATAFILE
'D:\DATABASE\ORACLE\ORCL\PAYROLL_IDX.DBF' SIZE 1000M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
/ --PAYROLL_TMP TABLESPACE CREATION
CREATE TEMPORARY TABLESPACE PAYROLL_TMP TEMPFILE
'D:\DATABASE\ORACLE\ORCL\PAYROLL_TMP.DBF' SIZE 1000M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
TABLESPACE GROUP ''
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
/-- USER 积己 棺 Tablespace Link
CREATE USER PAYROLL
IDENTIFIED BY PAYROLL
DEFAULT TABLESPACE PAYROLL_DAT
TEMPORARY TABLESPACE PAYROLL_TMP
QUOTA UNLIMITED ON PAYROLL_DAT;GRANT CONNECT, RESOURCE, DBA TO PAYROLL;
--PAYROLL_DAT TABLESPACE CREATION
CREATE TABLESPACE PAYROLL_DAT DATAFILE
'D:\DATABASE\ORACLE\ORCL\PAYROLL_DAT.DBF' SIZE 10000M AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
/ --PAYROLL_IDX TABLESPACE CREATION
CREATE TABLESPACE PAYROLL_IDX DATAFILE
'D:\DATABASE\ORACLE\ORCL\PAYROLL_IDX.DBF' SIZE 1000M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
/ --PAYROLL_TMP TABLESPACE CREATION
CREATE TEMPORARY TABLESPACE PAYROLL_TMP TEMPFILE
'D:\DATABASE\ORACLE\ORCL\PAYROLL_TMP.DBF' SIZE 1000M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
TABLESPACE GROUP ''
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
/-- USER 积己 棺 Tablespace Link
CREATE USER PAYROLL
IDENTIFIED BY PAYROLL
DEFAULT TABLESPACE PAYROLL_DAT
TEMPORARY TABLESPACE PAYROLL_TMP
QUOTA UNLIMITED ON PAYROLL_DAT;GRANT CONNECT, RESOURCE, DBA TO PAYROLL;
解决方案 »
- 问个impdp的问题
- 请教关于Oracle缓存使用的问题
- 求助
- 求教c语言调用oracle存储过程问题
- 使用not in和 not exists这两sql为啥结果不一样?
- MySQL迁移oracle问题
- ORA-00932: inconsistent datatypes: expected - got - 存储过程如何将两个查询的结果合在一起放进游标
- 请教:在p4上装了oracle8.1.7后,每次启动java报错6次,现在有几个程序都起不来
- 我现在不能放分了 怎么办呢?
- 关于存储过程游标insert into子查询结果丢失的疑问
- oracle 下面的 REDO01.LOG 文件被清理垃圾时给删除了,现在ORACLE数据库启动不了.怎么办啊.
- 求写一基础函数
然后cmd进入dos窗口,输入:
imp PAYROLL/PAYROLL file=路径\payroll.dmp full=y
上面两步就可以了。
接着CMD, 输入 imp User ID/Password@SID file=(payroll.dmp的路径,可以直接把文件拉进来) full=y
授权对象是PAYROLL 可以用这个做用户名!这样就不需要改动!