Home > Database > Mysql Tutorial > body text

Linux下IMP数据库文件记录

WBOY
Release: 2016-06-07 16:58:29
Original
1204 people have browsed it

初学Linux下oracle数据库IMP/EXP,昨天在IMP oracle数据库时候一直提示说IMP-00002,不能打开指定路径下的*.dmp文件。网路查询没

初学Linux下Oracle数据库IMP/EXP,昨天在IMP oracle数据库时候一直提示说IMP-00002,不能打开指定路径下的*.dmp文件。网路查询没有找到答案,今天请教ERP厂商,答复说权限问题。于是晚上再次更正文件夹的权限,然后重新将*.dmp文件copy到Linux指定目录下,在做IMP动作之前,再次网路搜索了下,在一片文章中看到路径的写法跟之前的写法不同(之前写法:file=\U1\LinuxTEST\*.DMP;网路上的写法:FILE=/U1/LinuxTEST/*.DMP),按照这个路径写法输入完成整个命令,ENTER,哈,顺利进行IMP动作。

另外,,log要记得写目录,如:log=/u1/Linuxtest/db_name.log

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!