How to import an oracle dump into a different tablespace
来源:互联网 发布:万国数据 待遇 编辑:程序博客网 时间:2024/05/18 02:41
With your .DMP file, create a SQL file containing the structure (Tables): (The default path of the index file is C:\Users\Administrator)
imp <xe_username>/<password>@XE file=<filename.dmp> indexfile=index.sql full=y
Open the indexfile (index.sql) in a text editor that can do find and replace over an entire file, and issue the following find and replace statements IN ORDER (ignore the single quotes.. '):
Find: 'REM<space>' Replace: <nothing>
Find: '"<source_tablespace>"' Replace: '"<Your_tablespace>"'
Find: '...' Replace: 'REM ...'
Find: 'CONNECT' Replace: 'REM CONNECT
Save the indexfile, then run it against your Oracle Express Edition account (I find it's best to create a new, blank XE user account - or drop and recreate if I'm refreshing): sqlplus <xe_username>/<password>@XE @index.sql
Finally run the same .DMP file you created the indexfile with against the same account to import the data, stored procedures, views etc:
imp <xe_username>/<password>@XE file=<filename.dmp> fromuser=<original_username> touser=<xe_username> ignore=y
- How to import an oracle dump into a different tablespace
- How to import an oracle dump in an different tablespace ( 如何将一个包含表空间信息的dmp文件导入到另一个表空间)
- How to use an ActiveX script task to import data into a new Excel file
- How to import a static library into your test project?
- How to import a SQL Server .bak file into MySQL?
- How to group anagrams in a string into an array
- How to compile a TCL script into an EXE program
- How to burn an ISO-image into a DVD
- How to Export/import database dump correctly
- How to import Ocx into MFC project
- How to Import Products into Magento
- How to import xml data into excel
- How to import Gradle project into eclipse
- How to import products into Magento?
- How to import Gradle project into eclipse .
- How to import a certificate file into a Java key store file?
- how to dump oracle block
- How to import a batch of files into vob in ClearCase
- 关于VC预定义常量_WIN32,WIN32,_WIN64
- 一个简单的HTML5摇一摇实例
- java操作Oracle的CLOB类型
- ACM学习计划 (用来激励自己!)
- yarn环境跑mapreduce报错某个container 600s未报告进度超时被杀
- How to import an oracle dump into a different tablespace
- C/S和B/S的区别
- SQL Server 不允许保存更改
- map中的pair用法
- Java如何单步跟踪Debug
- Android动画之一:Drawable Animation
- 分析Android 根文件系统启动过程
- 信息图:谁让马云成为中国首富的?
- gcc remove comments