如何在Oracle 11g(Application Express Edition)中导出导入数据库? [英] How To Export-Import Database in Oracle 11g(Application Express Edition)?

问题描述

我是Oracle 11g的初学者.我已经在Oracle 11g(Application Express)中创建了一个数据库.

I am beginner in Oracle 11g. I have created a database in oracle 11g(Application Express).

我想导出具有所有数据(整个工作区)的数据库，并将其导入到我已经安装了Oracle的另一台计算机上.是否有任何方法可以将整个工作区导出-导入到oracle 11g应用程序express中?

I want to export this database with all data(whole workspace) and import this to another computer where I already have installed Oracle.Is there any way to export-import the whole workspace in oracle 11g application express?

推荐答案

完整的数据库导出/导入使用

For a full database export/import use

exp user@DB FULL=Y FILE=PATH_TO_DUMPFILE
imp user@DB FULL=Y FILE=PATH_TO_DUMPFILE

用户必须具有EXP_FULL_DATABASE和IMP_FULL_DATABASE角色(或类似的角色，例如DBA).数据库是您的数据库(例如XE，如果您使用的是专业版)

The user must have EXP_FULL_DATABASE resp IMP_FULL_DATABASE role (or something equivalent, like DBA). DB is your database (e.g. XE, if you have expreess edition)

这篇关于如何在Oracle 11g(Application Express Edition)中导出导入数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！