设置 Oracle 环境变量 导入 导出 数据

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

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

检测是否设在对即可。