问题描述
我将如何从转储文件创建数据库?我的系统上没有具有相同结构的现有数据库，因此它必须包含作业、事件、表等.
How would I go about creating a database from a dump file? I do not have an existing database with the same structure on my system so it has to be complete with jobs, events, tables, and so on.
我将转储和日志文件放在 E: 驱动器中
I placed the dump and log file in E: drive
我已经尝试过导入实用程序
I have tried the import utility
E:/>impdp system/tiger@oratest FILE=WB_PROD_FULL_20MAY11.dmp
但我收到错误
invalid argument value
bad dump file specification
unable to open dump file "E:appadminoratestdpdumpWB_PROD_F
ULL_20MAY11.dmp" for read
unable to open file
unable to open file
(OS 2) The system cannot find the file specified.
当我在 Windows 资源管理器中看到 DMP 文件(取自 Linux 服务器)显示为崩溃转储文件时
And when I see in Windows Explorer DMP file(taken from Linux server) is showing as Crash dump file
我不明白如何解决这个问题.请帮我解决这个问题.
I don't understand how I can resolve this issue. Please help me to solve this issue.
我是 Oracle 的完全新手...
I'm a complete newbie on Oracle...
推荐答案
数据库是如何导出的?
如果它是使用
exp导出的，并且导出了完整的架构，则
If it was exported using
expand a full schema was exported, then
创建用户:
Create the user:
create user <username> identified by <password> default tablespace <tablespacename> quota unlimited on <tablespacename>;
授予权利:
Grant the rights:
grant connect, create session, imp_full_database to <username>;
使用 imp 开始导入:
imp <username>/<password>@<hostname> file=<filename>.dmp log=<filename>.log full=y;
如果是使用expdp导出的，则使用impdp开始导入:
If it was exported using expdp, then start the import with impdp:
impdp <username>/<password> directory=<directoryname> dumpfile=<filename>.dmp logfile=<filename>.log full=y;
看错误日志，好像没有指定目录，所以Oracle尝试在默认目录(即E:appVensi)中找到).dmp文件adminoratestdpdump
Looking at the error log, it seems you have not specified the directory, so Oracle tries to find the dmp file in the default directory (i.e., E:appVensiadminoratestdpdump).
要么将导出文件移动到上述路径，要么创建一个指向dmp文件所在路径的目录对象，并将对象名称传递给impdp上面的命令.
Either move the export file to the above path or create a directory object to pointing to the path where the dmp file is present and pass the object name to the impdp command above.
这篇关于如何从 dmp 文件和日志文件导入 Oracle 数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！