---
title: "设置 Oracle 环境变量  导入 导出 数据"
author: "backbase"
date: "2010-06-02T16:53:13Z"
tags: []
categories: ["数据库"]
slug: "oracle"
draft: false
lastmod: "2010-06-02T17:21:21Z"
id: 682176
url: "https://backbase.iteye.com/blog/682176"
---

为导入数据库创建表空间和用户

sqlplus system/password

conn /as sysdba

create tablespace User datafile 'D:\\Oracle10g\\XXXX .dbf' size 500M;

create user User identified by password default tablespace User ;

grant dba to User ;

exit

导入数据库

imp User/password file=d.dmp full=y

导出

exp User/password@XE file=d:\\d.dmp owner=(User)

逆向操作

连接数据库  
sqlplus system/password  
系统dba  
conn /as sysdba  
删除用户：  
DROP TABLESPACE User INCLUDING CONTENTS AND DATAFILES;  
drop user User cascade;

 

补充：

ubuntu：下设置jdk + tomcat + oralce 环境变量

 

终端输入 sudo gedit /etc/profile 在文件中添加如下的内容

 

#set java environment

JAVA\_HOME=/home/username/java/jdk1.6.0\_19

export JRE\_HOME=/home/username/java/jdk1.6.0\_19/jre

export CLASSPATH=.:$JAVA\_HOME/lib:$JRE\_HOME/lib

 

#set tomcat environment

export CATALINA\_HOME="/home/username/java/apache-tomcat-6.0.26"

 

#oracle environment variable

export ORACLE\_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/

#oracle database name

export ORACLE\_SID=XE

#character and language set 

export NLS\_LANG=AMERICAN\_AMERICA.AL32UTF8

#Search path for shared libraries

export LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib

#Search path used by SQL Command Line

export SQLPATH=$ORACLE\_HOME/sqlplus/admin

 

export PATH=$PATH:$JAVA\_HOME/bin:$JRE\_HOME/bin:$CATALINA\_HOME/bin:$ORACLE\_HOME/bin

 

保存退出：在终端输入:java ,javac ,$CATALINA\_HOME/bin/startup.sh , sqlplus system/password as sysdba

检测是否设在对即可。