简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

linux 命令行下，oracle数据库的导入、导出命令

WBOY
Release： 2016-06-07 15:19:20
Original
2604 people have browsed it

//在命令行下使用如下语句进行备份： exp omsuser/omsuser@orcl file=/home/lxm/omsfnaoc/data/oms.dmp exp zhang/zhang@orcl file=/home/lxm/omsfnaoc/data/zhang.dmp //导入数据库 imp userid=omsuser/omsuser@orcl file=/home/lxm/omsfnaoc/data/oms.dmp

//在命令行下使用如下语句进行备份：
exp omsuser/omsuser@orcl file=/home/lxm/omsfnaoc/data/oms.dmp

exp zhang/zhang@orcl file=/home/lxm/omsfnaoc/data/zhang.dmp

//导入数据库
imp userid=omsuser/omsuser@orcl file=/home/lxm/omsfnaoc/data/oms.dmp fromuser=omsuser touser=omsuser

Related labels：
linux oracle Order Command Line import Export database
source：php.cn
Previous article：MySQL系列：innodb源码分析之线程并发同步机制 Next article：SqlServer示例数据库Northwind（一）实体关系
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
Latest Articles by Author
Latest Issues
Linux Bash: Easily delete HTML table data blocks I have an html file that is processed using a bash script and want to remove empty tables....
From 2024-04-02 09:13:43
0
1
332
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
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！