Import and Export Oracle10g in Ubuntu

Import and Export Oracle10g in Ubuntu: add the following code to/etc/profile: exportORACLE_HOME =/usr/lib/oracle/xe/app/oracle/product/10.2.0/serverexportPATH = $ PATH: $ ORACLE_HOME/binexportNLS_LANG = AMERICAN_AMERICA.AL32U

Import and Export Oracle 10 Gb in Ubuntu:

Add the following code to/etc/profile:
Export ORACLE_HOME =/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
Export PATH = $ PATH: $ ORACLE_HOME/bin
Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ LD_LIBRARY_PATH

Set Environment Variables
Shell
1. Enter the oracle user su-oracle
2 exp (the user whose username has the dba permission to export)
3 imp)

Linuxidc Disclaimer: This article only represents the author's personal opinion and has nothing to do with the Linux community. Its originality, as well as the statement text and content in this article have not been confirmed by this site, this article and all or part of the content, the authenticity, integrity, timeliness of this site do not make any warranty or commitment, for your reference only, please verify the relevant content on your own.